Military Time Subtraction

[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

 

[Biff]

Hi Mark,

=(F5-E5)*24

and format as GENERAL

Biff

 

[Mike]

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

 

[Aladin Akyurek]

=(TEXT(F5,"00\:00")-TEXT(E5,"00\:00"))*24

Format the formula cell as General.

 

[Ron Rosenfeld]

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

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

 

[MWB]

Thanks for the help.

Mark