Military Time in Excel & Google Sheets

Written by

Editorial Team

Reviewed by

Steve Rynearson

Last updated on August 14, 2020
Download Example Workbook

Download the example workbook

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

Military time Main

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:

number format button

Next, select Time and select the Military time format:

excel 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’:

date format google sheets

Then select one of the military formats:

military time format google sheets

This results in:

Military time Google

AI Formula Generator

Try for Free

Excel Practice Worksheet

practice excel worksheet

Practice Excel functions and formulas with our 100% free practice worksheets!

  • Automatically Graded Exercises
  • Learn Excel, Inside Excel!

Free Download

Return to Excel Formulas List