Adding hours and minutes together

C

Chaz

How can I add hours and minutes together to get the whole
sum. For example, the way I'm doing it now, when I add
5:30, 7:30, 10:00, and 8:00, it comes out to be 7:00 (or
something like this), as though it is a clock that ran
past midnight. I want it to give me the answer of 31:00.
What am I doing wrong and is there an answer?
 
S

saziz

Chaz said:
*How can I add hours and minutes together to get the whole
sum. For example, the way I'm doing it now, when I add
5:30, 7:30, 10:00, and 8:00, it comes out to be 7:00 (or
something like this), as though it is a clock that ran
past midnight. I want it to give me the answer of 31:00.
What am I doing wrong and is there an answer? *
Click to expand...

Chaz,
Excel time ref. is always 24 hrs. so if you divide your answer (7:00
by 24 it whould give you 31. Try it.
sazi
 
S

saziz

Chaz said:
*How can I add hours and minutes together to get the whole
sum. For example, the way I'm doing it now, when I add
5:30, 7:30, 10:00, and 8:00, it comes out to be 7:00 (or
something like this), as though it is a clock that ran
past midnight. I want it to give me the answer of 31:00.
What am I doing wrong and is there an answer? *
Click to expand...
Chaz,
I appoligize you should multiply by 24 not divide.
Sazi
 
T

Tom Ogilvy

t = timeValue("5:30") + timevalue("7:30") + TimeValue("10:00") +
timevalue("8:00")
? csng(t)
1.291667
? t * 24
31
 
Top