Page 314 - TP_IT_V1.0_C9_flipbpookl
P. 314
Formatting a Range of Cells to Display Time
Time is indicated on the computer as 10:35:53 AM. The common format of this is hh:mm:ss AM/PM . Here, hh means
hours, mm means minutes and ss means second.
To change the format of time, follow the given steps:
Step 1: Select the range of cells with the numeric values entered as time.
Step 2: Click on the Format → Cells option from the Menu bar.
The Format Cells dialog box opens.
Step 3: Select the Numbers tab.
Step 4: Click on the Time category from the Category list box.
Step 5: Select the desired format of the number from the Format list box.
Step 6: Click on the OK button.
312 Trackpad Information Technology (Ver. 1.0)-IX

