G
Guest
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!
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!