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?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. celia

    Calculate fees based on the percentage given

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

    macro to calculate percentage

    vikram, May 3, 2004, in forum: Microsoft Excel Misc
    Replies:
    1
    Views:
    1,017
    Bob Phillips
    May 3, 2004
  3. Guest
    Replies:
    2
    Views:
    380
    Bob Phillips
    Jun 17, 2006
  4. Wanna Learn

    calculate time does not calculate

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

Share This Page