SUBSIM Radio Room Forums - View Single Post

robj250 · 07-14-06, 10:55 PM

I know this is an unusual request, but you see I'm trying to design an Excel spreadsheet that will calculate time. There are 2 factors involved. One reference to TIME is in a cel formatted for TIME ie 4:11. The second factor is the are 2 cells relating to TIME but are formated GENERAL. One is 3 representing 3 hours. The other is 43 representing 43 minutes. Now what I'm trying to do is add the 3 hours (which is a general format) and the 43 minutes (which is a general format) to 4:11 (which is a time format) and come up with the answer of what the time would be when the calculations are completed, and I want this in TIME format.
So if I was to take 4:11 and add 3:43 to it I should get 7:54 but instead I am getting 20:37.

I need a formula which will take TIME and add two different general format number 3 and 43 and make it come up with a TIME of 7:54.

I have no idea what kind of formula I would have to come up with as I am not an Excel expert, just a simple 70 year old man.

07-14-06, 10:55 PM	#1
robj250 Sea Lord Join Date: Mar 2006 Location: Port Hardy, BC, Canada 75 yo with M.S. & C.O.P.D. & heart problems Posts: 1,930 Downloads: 1 Uploads: 0	Desperately Need Excel Expert I know this is an unusual request, but you see I'm trying to design an Excel spreadsheet that will calculate time. There are 2 factors involved. One reference to TIME is in a cel formatted for TIME ie 4:11. The second factor is the are 2 cells relating to TIME but are formated GENERAL. One is 3 representing 3 hours. The other is 43 representing 43 minutes. Now what I'm trying to do is add the 3 hours (which is a general format) and the 43 minutes (which is a general format) to 4:11 (which is a time format) and come up with the answer of what the time would be when the calculations are completed, and I want this in TIME format. So if I was to take 4:11 and add 3:43 to it I should get 7:54 but instead I am getting 20:37. I need a formula which will take TIME and add two different general format number 3 and 43 and make it come up with a TIME of 7:54. I have no idea what kind of formula I would have to come up with as I am not an Excel expert, just a simple 70 year old man. Last edited by robj250; 07-14-06 at 11:14 PM.