Military Time in Excel & Google Sheets

This tutorial will demonstrate how to format times as military time in Excel and Google Sheets.

Military Time Excel

To format time as military time all you need to do is change the time number formatting. To do this, first open the Format Cells Menu.

The Format Cells Menu can be accessed with the shortcut CTRL + 1 or by clicking this button:

Next, select Time and select the Military time format:

Notice that in the ‘Sample’ area you can see the impact the new number format will have on the active cell.

Military Time Google Sheets

To change the time format to Military in Google Sheets go to Format > … > ‘More date and time formats’:

Then select one of the military formats:

This results in: