Yes, I know.... but I did not get that the OP wanted leading numbers from
his original message, so I was wondering why Gary''s Student gave him a
format pattern that would return them.

--
Rick (MVP - Excel)


"Dave Peterson" wrote in message
...
[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