Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How can I add times, i.e., 1:45:30 + 2:10:20?
How can I add the times of individual phone calls to get the total time spent
calling from a particular phone number? The phone call record has been placed on an Excel spreadsheet in the hour:minute:second format and sorted by phone number with associated length of call. I've formatted the column for times. In the next column, cell G22, I've placed the formula =SUM(F4:F22); the formula returns zero. Why won't the formula total the time? Thanks. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How can I add times, i.e., 1:45:30 + 2:10:20?
Have you formatted the results cell as [h]:mm:ss
-- --- HTH Bob (change the xxxx to gmail if mailing direct) "wahjazz" wrote in message ... How can I add the times of individual phone calls to get the total time spent calling from a particular phone number? The phone call record has been placed on an Excel spreadsheet in the hour:minute:second format and sorted by phone number with associated length of call. I've formatted the column for times. In the next column, cell G22, I've placed the formula =SUM(F4:F22); the formula returns zero. Why won't the formula total the time? Thanks. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How can I add times, i.e., 1:45:30 + 2:10:20?
It will. If your total time is greater than 24 hours, you need the format
[h]:mm:ss to display them. Otherwise, Excel converts anything greater than 24 hours to days. -- Regards, Fred "wahjazz" wrote in message ... How can I add the times of individual phone calls to get the total time spent calling from a particular phone number? The phone call record has been placed on an Excel spreadsheet in the hour:minute:second format and sorted by phone number with associated length of call. I've formatted the column for times. In the next column, cell G22, I've placed the formula =SUM(F4:F22); the formula returns zero. Why won't the formula total the time? Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Adding up times from a Triathalon | Excel Discussion (Misc queries) | |||
Calculating difference between two times | Excel Worksheet Functions | |||
Avg Times in MOD fx using selected rows | Excel Worksheet Functions | |||
Charting and analyzing Times' times data for trends | Excel Discussion (Misc queries) | |||
SUMPRODUCT ON TIMES | Excel Worksheet Functions |