Help with Time Keeping Formula
 

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!

Help with Time Keeping Formula
 

Barefoot Mark Wrote:
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!

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

=MOD(G476-E476,1)*24

format cell as general


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=521289