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

[Jockstrap]

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!

[Audiojoe]

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

[NickDell]

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