How do I cast time when the total exceeds 24 hours
 

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?

How do I cast time when the total exceeds 24 hours
 

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?

How do I cast time when the total exceeds 24 hours
 

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?

How do I cast time when the total exceeds 24 hours
 

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?

How do I cast time when the total exceeds 24 hours
 

[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

How do I cast time when the total exceeds 24 hours
 

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

How do I cast time when the total exceeds 24 hours
 

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

How do I cast time when the total exceeds 24 hours
 

Simple stuttering.
--
Gary''s Student - gsnu200904


"Dave Peterson" wrote:

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

How do I cast time when the total exceeds 24 hours
 

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

How do I cast time when the total exceeds 24 hours
 

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

How do I cast time when the total exceeds 24 hours
 

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

How do I cast time when the total exceeds 24 hours
 

Maybe more than enough <vbg.

Rick Rothstein wrote:

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

--

Dave Peterson