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
   309   310   311   312   313   314   315   316   317   318   319