Calculate Percentage of time

Discussion in 'Microsoft Excel Misc' started by FrankTimJr, Jan 16, 2009.

  1. FrankTimJr

    FrankTimJr Guest

    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, Jan 16, 2009
    #1
    1. Advertisements

  2. FrankTimJr

    Chip Pearson Guest

    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
    <> 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?
     
    Chip Pearson, Jan 16, 2009
    #2
    1. Advertisements

  3. FrankTimJr

    FrankTimJr Guest

    Thank you!!

    "David Biddulph" wrote:

    > You assumed that Excel time is measured in hours, but it's measured in days,
    > so you need to multiply your answer by 24.
    > --
    > David Biddulph
    >
    > "FrankTimJr" <> wrote in message
    > news:...
    > > 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, Jan 16, 2009
    #3
    1. Advertisements

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 (here). After that, you can post your question and our members will help you out.
Similar Threads
  1. celia

    Calculate fees based on the percentage given

    celia, Nov 12, 2003, in forum: Microsoft Excel Misc
    Replies:
    1
    Views:
    338
    DavidP
    Nov 12, 2003
  2. vikram

    macro to calculate percentage

    vikram, May 3, 2004, in forum: Microsoft Excel Misc
    Replies:
    1
    Views:
    1,343
    Bob Phillips
    May 3, 2004
  3. fallouh

    Pivot Table-Calculate Percentage of Parent Row Item

    fallouh, Jun 22, 2004, in forum: Microsoft Excel Misc
    Replies:
    1
    Views:
    1,929
    BrianB
    Jun 23, 2004
  4. Guest
    Replies:
    0
    Views:
    300
    Guest
    Nov 25, 2004
  5. Guest
    Replies:
    1
    Views:
    228
    Frank Kabel
    Dec 11, 2004
  6. Guest
    Replies:
    2
    Views:
    624
    Bob Phillips
    Jun 17, 2006
  7. Wanna Learn

    calculate time does not calculate

    Wanna Learn, Aug 18, 2008, in forum: Microsoft Excel Misc
    Replies:
    2
    Views:
    551
    MillyD
    Aug 18, 2008
  8. Pearl
    Replies:
    1
    Views:
    237
    JLatham
    Apr 17, 2010
Loading...