Format time to not include seconds and AM/PM
In the cells (whole column or whole row will work the same way) of interest,
set the cell format to Custom "h:mm" (for 1:30) or to Custom "hh:mm" (for
01:30). (My understanding is that you do not want seconds NOR AM/PM,
correct? If not, just use the "1:30 PM" format under the Time category.)
To do this, right-click on the cell/row/column of interest and select
"Format Cells," go to the "Number" tab then choose the appropriate category
("Custom" for the first two, "Time" for the third), and then the "Type,"
click "OK" when you are finished.
Hope this helps, Jim
|