How to Convert Military Time on an Excel Spreadsheet

1. Select the cell with military time. Place your mouse over the cell. Click your left mouse button once to select the cell. The cell is active when outlined with a black border. In addition, the status bar will indicate 'Ready' in the lower-left corner of the program window.
2. Right-click the cell. Open the short-cut menu by right-clicking the cell. Click 'Format cells...' from the short-cut menu. The 'Format Cells' dialogue box will open.
3. Choose a format. Make sure the current tab is 'Number.' Select 'Time' from the 'Category' section of the 'Number' tab. In the 'Type' section, select the time format you would like to use. Time formats marked with an asterisk adjust based on the regional settings of your operating system.
4. Accept the changes. Click 'OK' to change the military time to your selected format.