hh:mm:ss keeps converting to a date
Select your date cells and then click on FORMAT and then select cells. In
the CATEGORY pane select CUSTOM and then in the type pane select the
following format:
[h]:mm:ss
--
Kevin Backmann
"Brian James" wrote:
I am trying to work on a spreadsheet for work where I am keeping track of
time by hours, minutes and seconds. I format the cells for hh:mm:ss.00 but
each time I enter the hours, seconds, minutes, it converts to a date field
and changes to another hh:mm:ss value. The value I have entered is 42:37:26
|