Help with Time Keeping Formula

B

Barefoot Mark

I use Excel to create very complicated schedules. I use military time for
the starting and beginng times, and then add them, to come up with a total of
hours. The problem is when the ending time is past 11:59 PM. it seems to
subtract, rather than add. Here is an example of the formula:

=(HOUR(G476)+(MINUTE(G476)*0.01666))-(HOUR(E476)+(MINUTE(E476)*0.01666))

It works great as long as both times are within the same 24 hours. Any
suggestions?

Thanks!
 
D

daddylonglegs

Barefoot said:
I use Excel to create very complicated schedules. I use military time
for
the starting and beginng times, and then add them, to come up with a
total of
hours. The problem is when the ending time is past 11:59 PM. it seems
to
subtract, rather than add. Here is an example of the formula:

=(HOUR(G476)+(MINUTE(G476)*0.01666))-(HOUR(E476)+(MINUTE(E476)*0.01666))

It works great as long as both times are within the same 24 hours.
Any
suggestions?

Thanks!
Click to expand...

It doesn't need to be that elaborate....

=MOD(G476-E476,1)*24

format cell as general
 
Top