Gary''s Student said:If you have a cell that adds up times, format that cell to:
Format > Cell... > Number > Custom > [hhhh]
--
Gary''s Student - gsnu200904
arm266 said: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?
arm266 said: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 said:If you have a cell that adds up times, format that cell to:
Format > Cell... > Number > Custom > [hhhh]
--
Gary''s Student - gsnu200904
arm266 said: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?
Rick said: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 said: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 said:If you have a cell that adds up times, format that cell to:
Format > Cell... > Number > Custom > [hhhh]
--
Gary''s Student - gsnu200904
:
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 said:[hhhh] will show leading 0's.
Rick said: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 said:That option isn't available in Excel 2003 but the alternative is
[h]:mm:ss.
Thanks for pointing me in the right direction.
:
If you have a cell that adds up times, format that cell to:
Format > Cell... > Number > Custom > [hhhh]
--
Gary''s Student - gsnu200904
:
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?
Rick said: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 said:[hhhh] will show leading 0's.
Rick said: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)
That option isn't available in Excel 2003 but the alternative is
[h]:mm:ss.
Thanks for pointing me in the right direction.
:
If you have a cell that adds up times, format that cell to:
Format > Cell... > Number > Custom > [hhhh]
--
Gary''s Student - gsnu200904
:
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 said:I can't speak for Gary's Student.
I would have used [hh] <vbg>.
Rick said: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 said:[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)
That option isn't available in Excel 2003 but the alternative is
[h]:mm:ss.
Thanks for pointing me in the right direction.
:
If you have a cell that adds up times, format that cell to:
Format > Cell... > Number > Custom > [hhhh]
--
Gary''s Student - gsnu200904
:
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 said:I can't speak for Gary's Student.
I would have used [hh] <vbg>.
Rick said: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 said:[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)
That option isn't available in Excel 2003 but the alternative is
[h]:mm:ss.
Thanks for pointing me in the right direction.
:
If you have a cell that adds up times, format that cell to:
Format > Cell... > Number > Custom > [hhhh]
--
Gary''s Student - gsnu200904
:
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?
Rick said: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 said:I can't speak for Gary's Student.
I would have used [hh] <vbg>.
Rick said: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)
[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)
That option isn't available in Excel 2003 but the alternative is
[h]:mm:ss.
Thanks for pointing me in the right direction.
:
If you have a cell that adds up times, format that cell to:
Format > Cell... > Number > Custom > [hhhh]
--
Gary''s Student - gsnu200904
:
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 said:Just because I like leading 0's in my times (and dates, too).
Rick said: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 said: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)
[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)
That option isn't available in Excel 2003 but the alternative is
[h]:mm:ss.
Thanks for pointing me in the right direction.
:
If you have a cell that adds up times, format that cell to:
Format > Cell... > Number > Custom > [hhhh]
--
Gary''s Student - gsnu200904
:
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?
Rick said:Oh, okay. Of course, the value the OP is formatting is not a "time" value
per se; rather, it is a summation of hours where he appears to want to see
the total number of hours, which is why I figured he would not want the
leading zero if the total was less than 10. In any case, he has enough
information in this thread that he should be able to pick whatever format he
wants/needs.
--
Rick (MVP - Excel)
Dave Peterson said:Just because I like leading 0's in my times (and dates, too).
Rick said: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)
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)
[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)
That option isn't available in Excel 2003 but the alternative is
[h]:mm:ss.
Thanks for pointing me in the right direction.
:
If you have a cell that adds up times, format that cell to:
Format > Cell... > Number > Custom > [hhhh]
--
Gary''s Student - gsnu200904
:
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?
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.