Calculate Percentage of time

F

FrankTimJr

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?
 
D

David Biddulph

You assumed that Excel time is measured in hours, but it's measured in days,
so you need to multiply your answer by 24.
 
C

Chip Pearson

Try

=(AverageTime*24)/8

You could also write the formula as

=AverageTime/(8/24)

Excel stores times as a fraction of a 24-hour day (6:00 = 0.25, 12:00
= 0.5, 18:00 = 0.75, etc), so if you are doing arithmetic with the
number of hours (as in your value of 8 for hours/day), you need to
multiply by 24.

Format the cell for Percentage.

Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group, 1998 - 2009
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)
 
F

FrankTimJr

Thank you!!

David Biddulph said:
You assumed that Excel time is measured in hours, but it's measured in days,
so you need to multiply your answer by 24.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top