Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I'm trying to build a report that shows the callers percent of time (during
an 8 hour day) they spend on the phone. I have the callers total time for the Month and I need to calculate two things: Average amount of time spent on the phone per day (=Total Time/# Days worked) Average % of time spent on the phone per day is where I'm confused. I thought I would just divide =((Total Time/# Days worked)/8) but I'm getting some strange results. For example, I have an Average time of 2:23:11, so just divide that number by 8 and I got 1.24%. What am I doing wrong? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Wrong sum value after calculate with Percentage | Excel Worksheet Functions | |||
How do I Calculate a percentage | Excel Discussion (Misc queries) | |||
convert from percentage of time to time using complex formula in . | Excel Worksheet Functions | |||
Calculate percentage of time period | Excel Worksheet Functions | |||
calculate percentage | Excel Worksheet Functions |