Just because I like leading 0's in my times (and dates, too).



Rick Rothstein wrote:

Why? If the OP only had, say, a total of 8 hours for some reason (maybe the
employee was out most of the month), [hh] would show 08 whereas as [h] would
show 8 (and it would still show hours with more than 2-digits correctly as
well).

--
Rick (MVP - Excel)

"Dave Peterson" wrote in message
...
I can't speak for Gary's Student.

I would have used [hh] <vbg.

Rick Rothstein wrote:

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

--

Dave Peterson

--

Dave Peterson