| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#11
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#12
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| add 10,0015:15 hours to 03:53 Hours to a total time | Excel Worksheet Functions | |||
| calculating timesheet, time-in/time-out = total hours & minutes, . | Excel Worksheet Functions | |||
| How do I summarize time that exceeds 24 hours? | Excel Worksheet Functions | |||
| Can I get Excel to calculate hours:minutes when sum exceeds 24? | Excel Worksheet Functions | |||
| template or formula for start time -finish time -total hours ple | New Users to Excel | |||
Linear Mode
