How to Convert Military Time on an Excel Spreadsheet

By Contributor

Updated April 09, 2020

Microsoft Excel 2013 can use both military and civilian time formats. Using Excel's Time format options, you can convert from one to the other for times you have entered manually or times using Excel's current time function.

Tips

To convert military time yourself, add 12 hours to any time after 12:59 p.m. To convert military time to civilian time, subtract 12 hours from any time that shows more than 12 hours. For example, 1:00 p.m. is 13:00 hours in military time. Midnight is 24:00 hours.

Converting Civilian and Military Times

Type any civilian time that is after 12 noon, such as 2:00 PM, in an Excel worksheet cell. Click the Home tab and select Time from the Number menu.

Screenshot of selecting time from number menu in Excel.

Type the same time in another cell. Click the Home tab and this time click the small Arrow at the bottom of the ribbon's Number section to launch the Format Cells window. Click the Time option under the Number tab and and select 1:30:55 PM option. This shows civilian time with hours, minutes and seconds.

Screenshot of military time option in Excel.

Enter the same time in a third cell. Open the Format Cells window again. From the Time options, click 13:30, which displays military time based on a 24-hour clock.

Screenshot of clicking option in Excel.

Enter the same time in a fourth cell. This time, select the 13:30:55 option, which displays military time with seconds, not just hours and minutes.

Screenshot in Excel.

Converting Excel's Current Date and Time Formula

Type =Now() in any blank worksheet cell. This is Excel's formula for showing the current date and time.

Screenshot of =NOW() function in Excel.

Press Enter to accept the formula you just typed. The current date and time is displayed, automatically using a military 24-hour clock.

Screenshot of Excel calculating time converison.

Type the =NOW() in another empty cell and press Enter. Click the Home tab, then the small Arrow in the Number section. Select Date under the Number tab. Scroll to the bottom of the options, select 3/14/12 1:30 PM and then click OK. This converts the military time format to civilian time.

Screenshot of changing military time to civilian time in Excel.
×