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!
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!