Tracking Time

[brucek]

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?

[Sloth]

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?