MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Subtracting Military Time

Posted by blepcd on September 24, 2001 6:49 AM

I have two inputs in military time format. How do I subtract the two numbers and get an hourly output in decimals?

Posted by Mark W. on September 24, 2001 7:57 AM

=(A2-A1)*24 will produce 5.25 where A2 contains
18:15 and A1 contains 13:00.