Hi Bill,

see

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

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

"Bill" wrote in message
...
how do you subtract military time? example 12:00 - 07:00 = 5 hours