Military Time

davidwdf · Jul 15, 2004

I need a calculation to subtract military time.

0800 Start Time
1600 End Time
= 8 hrs time spent

thank

Don Guillett · Jul 15, 2004

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 · Jul 15, 2004

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