Average number over hours
I have two columns Calls and total hrs. I want to know what the average # of calls per shift is. Normally I would just =avg(Calls, hours) but one's a number and one is time. So I tried doing avg(calls, text(hours)) and it doesn't calculate correctly.
How do I figure this?
Use the HOUR function to convert the time into hours.
So you formula would be: