Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: I'm trying to get average calls per hour but.....

  1. #1
    New Member
    Join Date
    Apr 2002
    Posts
    4
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default


    I can't seem to make it work!!

    The time that our agents are on the phone is formatted as [hh]:mm:ss and the calls are formatted as a normal number.

    What formula do I use to get calls per hour. For instance if the time they are on the phone is 02:00:00 and they have 4 calls then that's 2 per hour but I cant work out the formula

    Please help!

  2. #2
    Board Regular
    Join Date
    Feb 2002
    Location
    Where the wild roses grow
    Posts
    285
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default


    Howdy,

    Have you tried taking a cell that's formatted in that way and changing the format to a number? An hour is 0.04, just as 24 hours come out as 1. With this in mind, try this formula:

    =SUM(Cell with amount of calls in)/(Cell with time in*0.04)/600

    Audiojoe
    S-s-s-s-sussudio

  3. #3
    New Member
    Join Date
    Jan 2011
    Posts
    1
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: I'm trying to get average calls per hour but.....

    I was trying the same - this formula worked Great! It is nice to have an understanding of how Excel stores time data, Thank You!

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •