how do you subtract military time? example 12:00 - 07:00 = 5 hour.

[Bill]

how do you subtract military time? example 12:00 - 07:00 = 5 hours

 

[Niek Otten]

Hi Bill,

see

http://www.cpearson.com/excel/datetime.htm#AddingTimes

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel