Military Time Subtraction

  • Thread starter Thread starter MWB
  • Start date Start date
M

MWB

I do my time sheet in military time. Is there a way to subtract military
time?
Let's say:

E5 F5 G5
0800 1700 9

How do I make it 9 and not 900?


Thanks
Mark
 
G5: Formula =HOUR(TIME(F5/100,MOD(F5,100),0)-TIME(E5/100,MOD(E5,100),0))+MINUTE(TIME(F5/100,MOD(F5,100),0)-TIME(E5/100,MOD(E5,100),0))/100
G5: Format General
 
I do my time sheet in military time. Is there a way to subtract military
time?
Let's say:

E5 F5 G5
0800 1700 9

How do I make it 9 and not 900?


Thanks
Mark
Click to expand...

And another method, if you have the Analysis Toolpak installed, and want a
decimal output (in other words -- 9.5 as a result for 9 hours 30 minutes):

=dollarde(F5/100,60)-dollarde(E5/100,60)


--ron
 
Back
Top