# Excel: Convert Between Standard Time & Military Time

You can use the following formulas to convert between standard time and military time in Excel:

Formula 1: Convert Standard Time to Military Time

`=TEXT(A2,"HHMM")`

This particular formula converts the standard time in cell A2 to military time.

Formula 2: Convert Military Time to Standard Time

`=TIMEVALUE(LEFT(A2,2)&":"&RIGHT(A2,2))`

This particular formula converts the military time in cell A2 to standard time.

The following examples show how to use each formula in practice.

## Example 1: Convert Standard Time to Military Time

Suppose we have the following list of standard times in Excel:

We can type the following formula into cell B2 to convert the standard times to military times:

`=TEXT(A2,"HHMM")`

We can then click and drag this formula down to each remaining cell in column B:

Column B now displays each standard time from column A as a military time.

Note: If you’d like to display the seconds in the military time as well, you can use the following formula instead:

`=TEXT(A2,"HHMMSS")`

The following screenshot shows how to use this formula in practice:

## Example 2: Convert Military Time to Standard Time

Suppose we have the following list of military times in Excel:

We can type the following formula into cell B2 to convert the military times to standard times:

`=TIMEVALUE(LEFT(A2,2)&":"&RIGHT(A2,2))`

We can then click and drag this formula down to each remaining cell in column B:

By default, the times in column B are shown as decimals.

To format these decimals as times, highlight the cell range B2:B10 and then click the Number Format dropdown on the Home tab and then click Time:

Column B will now display each military time from column A as a standard time: