Military Time

[davidwdf]

I need a calculation to subtract military time.

0800 Start Time
1600 End Time
= 8 hrs time spent

thank

 

[Don Guillett]

for your example, just subtract
=a1-b1 and format as number
for more complicated, such as the next day, look in here

http://tinyurl.com/42p8p

 

[filky]

The quickest way is probably =(+A1/100)-(A2/100) where A1 is 1600 and A
is 080