+ Reply to Thread
Results 1 to 3 of 3

averaging calls per hour formula assistance

  1. #1
    Registered User
    Join Date
    02-13-2008
    Posts
    3

    averaging calls per hour formula assistance

    good morning.

    I have a excel spreadsheet I create every morning for a call center and need assistance getting a true average of calls per hour when there are hours and minutes involved

    right now my formula says =(I7+K7)/HOUR(B7)
    so 32+6/7:46:57 which would equal 5.43 but its not taking the minutes into consideration (so the true answer would be 4.88)

    can anyone offer assistance on how I can include minutes?

    I appreciate it

  2. #2
    Forum Expert daddylonglegs's Avatar
    Join Date
    01-14-2006
    Location
    England
    MS-Off Ver
    2016
    Posts
    14,675
    Use this formula

    =(I7+K7)/B7/24

    format result cell as number

  3. #3
    Registered User
    Join Date
    02-13-2008
    Posts
    3
    worked like a champ. I wish I could say its hard to believe something so simple was so time consuming for me, but excel gives me a headache

    thanks you very much!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1