| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do you add times together to give a total time?
I want to add together a column of times on telephone calls.
|
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how do you add times together to give a total time?
If those times are in Excel time format, then you can just SUM them
and set the format of that cell as appropriate, maybe [mm]:ss - the square brackets instructs Excel not to wrap the number of minutes at 60 into hours, so that 1 hour and 30 minutes would show as 90:00 instead of 1:30:00. If the duration is in seconds, then you could have a formula like this: =SUM(S2:S1000)/60/60/24 with the cell formatted as time. Hope this helps. Pete On Feb 25, 1:03*am, cmt wrote: I want to add together a column of times on telephone calls. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need two different data types to give me a total | Excel Worksheet Functions | |||
| Help with adding times to give the result as the day | Excel Worksheet Functions | |||
| Product of Hrs & minutes times rate per hr to give a cost | Excel Discussion (Misc queries) | |||
| Calculation Total Time With Dates/Times That Overlaps | Excel Discussion (Misc queries) | |||
| If the total = between 17-20 give it a score of 5, and so on | Excel Discussion (Misc queries) | |||
Hybrid Mode
