[hhhh] will show leading 0's.



Rick Rothstein wrote:

I'm not sure why Gary''s Student suggest [hhhh] instead of just [h], but you
can use either of those for the Custom Format type... you are not restricted
to just the items in the Custom Format list... you can add your own (for
example, [h] or [hhhh]) by just selecting all the text currently shown in
the Type field and then just typing in whatever format pattern you want
there.

--
Rick (MVP - Excel)

"arm266" wrote in message
...
That option isn't available in Excel 2003 but the alternative is
[h]:mm:ss.
Thanks for pointing me in the right direction.

"Gary''s Student" wrote:

If you have a cell that adds up times, format that cell to:

Format Cell... Number Custom [hhhh]
--
Gary''s Student - gsnu200904


"arm266" wrote:

Autosum will cast up hours - such as a timesheet - until that reaches
24
hours, then it fails beyond that. How do I can the hours in a week,
month or
even year?

--

Dave Peterson