How-to Display Military Time in an Excel Spreadsheet

A few days ago, I had a user ask me a question on the blog about how she can display military time in Excel.

It is pretty simple to display in Excel but only if you know how Excel treats time.

Excel uses number to record dates and time.

For example, 1:30 PM on May 1, 2015 = 42125.5625

The 42125 = the number of days that have passed since January 1, 1900

The 0.5625 = 1:30 PM which is a fraction of 24 hours with 0 = 12 AM and 0.5 = Noon and 0.999305555555556 = 11:59 PM

So since Time in Excel is just a number, then to show Standard time vs Military time, we simply need to change the format of that number.

To do that, Select the cells you want to display as Military time and then change the Number FormatMilitary Time Number Format Menu

to the time display you desire:

Military Time Number FormatThen your numbers will now appear in Military Format. .

But what is that one time format at the bottom?  Can anyone tell me what the time format is that I show at the end of the video?  37:30:55?  Put it in the comments below.  I want to know 🙂  I am sure Pete knows 🙂


Video Demonstration

Thanks for being a fan!