Excel XP

Formatting Time in the Format Cells Dialog Box

The time can be formatted in many different ways in Excel XP. Here are a few ways it can appear:

13:30
1:30 PM

To Format the Appearance of Time in a Cell:

• Select the range of cells you want to format.
• Choose Format Cells from the menu bar.
• The Format Cells dialog box opens.
• Click the Number tab.
• Click Time in the Category drop-down list.
  
  
  
  
• Select the desired time format from the Type drop-down list.
• Click the OK button.