Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
(EXCEL 2003)
Cells [A1:A4300] I have time values of phone calls in hours, min, sec. Example: 0:11:34 1:04:45 .... if i use =SUM(A1:A4300) I get an output of: 146:09:49 I then want to take the number of days that the person worked (110) during this data set to find an average time per day on the phone. I don't think I am getting the correct output: Suggestions? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Time Formulas | Excel Discussion (Misc queries) | |||
Using Time in Formulas | Excel Discussion (Misc queries) | |||
*HELP* time formulas | Excel Worksheet Functions | |||
Time Formulas | Excel Discussion (Misc queries) | |||
Time formulas | Excel Discussion (Misc queries) |