| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Time (gentlemen, please)
I'm trying to add up a column of times (format/custom hh:mm) however, when 24
hours is reached and exceeded, the results start at 00:00 again rather than just continuing to add up. How can I get around this? Thanks -- Traa Dy Liooar Jock |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Time (gentlemen, please)
Format the cell with the SUM in it using Custom, as [hh]:mm. The
square brackets around the hh tell excel not to wrap hours above 24. Hope this helps. Pete On Aug 14, 4:00 pm, Jock wrote: I'm trying to add up a column of times (format/custom hh:mm) however, when 24 hours is reached and exceeded, the results start at 00:00 again rather than just continuing to add up. How can I get around this? Thanks -- Traa Dy Liooar Jock |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Time (gentlemen, please)
"Jock" wrote...
I'm trying to add up a column of times (format/custom hh:mm) however, when 24 hours is reached and exceeded, the results start at 00:00 again rather than just continuing to add up. How can I get around this? Give that cell the number format "[h]:mm:ss". The seconds portion is optional, but the hour portion needs the square brackets. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Time (gentlemen, please)
Thanks Pete
-- Traa Dy Liooar Jock "Pete_UK" wrote: Format the cell with the SUM in it using Custom, as [hh]:mm. The square brackets around the hh tell excel not to wrap hours above 24. Hope this helps. Pete On Aug 14, 4:00 pm, Jock wrote: I'm trying to add up a column of times (format/custom hh:mm) however, when 24 hours is reached and exceeded, the results start at 00:00 again rather than just continuing to add up. How can I get around this? Thanks -- Traa Dy Liooar Jock |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Time (gentlemen, please)
You're welcome, thanks for feeding back.
Pete On Aug 14, 4:22 pm, Jock wrote: Thanks Pete -- Traa Dy Liooar Jock "Pete_UK" wrote: Format the cell with the SUM in it using Custom, as [hh]:mm. The square brackets around the hh tell excel not to wrap hours above 24. Hope this helps. Pete On Aug 14, 4:00 pm, Jock wrote: I'm trying to add up a column of times (format/custom hh:mm) however, when 24 hours is reached and exceeded, the results start at 00:00 again rather than just continuing to add up. How can I get around this? Thanks -- Traa Dy Liooar Jock- Hide quoted text - - Show quoted text - |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Time (gentlemen, please)
On Tue, 14 Aug 2007 08:00:06 -0700, Jock
wrote: I'm trying to add up a column of times (format/custom hh:mm) however, when 24 hours is reached and exceeded, the results start at 00:00 again rather than just continuing to add up. How can I get around this? Thanks Format/Cells/Number Custom Type: [hh]:mm --ron |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| verify use of TIME Function, Find Quantity Level compare to time-d | Excel Discussion (Misc queries) | |||
| Formula to find Stop Time from Start Time and Total Minutes | Excel Worksheet Functions | |||
| template or formula for start time -finish time -total hours ple | New Users to Excel | |||
| Calculating days & time left from start date/time to end date/time | Excel Worksheet Functions | |||
| Remove time from a date and time field? Format removes the displa. | Excel Worksheet Functions | |||
Linear Mode
