I have a spreadsheet that tracks usage of software. The cell is formatted as
a custom format (h):hh:ss However when I click on a cell it is displayed as
clock time.
14:32:15 is displayed as 2:32:15 PM. I'm trying to track usage and the
formula I 'm using doesn't seem to recognize the time. Can I change the
format to something else?

try this custom format
[h]:mm:ss

also post the formula. If a formula doesn't recognise a time in one format,
it won't recognize the time in any format.

"brucek" wrote:

I have a spreadsheet that tracks usage of software. The cell is formatted as
a custom format (h):hh:ss However when I click on a cell it is displayed as
clock time.
14:32:15 is displayed as 2:32:15 PM. I'm trying to track usage and the
formula I 'm using doesn't seem to recognize the time. Can I change the
format to something else?