# Calculate Percentage of time

FrankTimJr
Guest
Posts: n/a

 16th Jan 2009
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?

Chip Pearson
Guest
Posts: n/a

 16th Jan 2009
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)

On Fri, 16 Jan 2009 14:14:00 -0800, FrankTimJr
<(E-Mail Removed)> wrote:

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

FrankTimJr
Guest
Posts: n/a

 17th Jan 2009
Thank you!!

"David Biddulph" wrote:

> You assumed that Excel time is measured in hours, but it's measured in days,
> --
> David Biddulph
>
> "FrankTimJr" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
> > 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 Rate This Thread Rate This Thread: 5 : Excellent 4 : Good 3 : Average 2 : Bad 1 : Terrible

 Posting Rules You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are Off Forum Rules

 Similar Threads Thread Thread Starter Forum Replies Last Post joeu2004 Microsoft Excel Worksheet Functions 0 14th Dec 2012 09:39 PM Pearl Microsoft Excel Misc 1 17th Apr 2010 09:13 PM Joe Microsoft Access Queries 3 5th Dec 2008 07:42 PM =?Utf-8?B?UmljYXJkbyBNb250ZWlybyA6Xik=?= Microsoft Excel Worksheet Functions 4 6th Jan 2006 03:46 PM TEAM Microsoft Excel Charting 1 28th Oct 2005 05:06 AM

Features