I am not getting the problem, but maybe if you format as [h]:mm:ss

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Brian James" <Brian wrote in message
...
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