ExcelBanter - how do you subtract military time? example 12:00

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - how do you subtract military time? example 12:00 - 07:00 = 5 hour. (https://www.excelbanter.com/excel-worksheet-functions/5149-how-do-you-subtract-military-time-example-12-00-07-00-%3D-5-hour.html)

Bill

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

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

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

All times are GMT +1. The time now is 12:33 AM.