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?

Answers


Use the HOUR function to convert the time into hours.

So you formula would be:

=avg(calls, HOUR(hours))

Need Your Help

How to auto execute commands after opening a file in GNU Emacs

emacs elisp

How to do something like this: auto execute commands (split-window-right) (follow-mode) (visual-line-mode) after opening a file.

SCRIPT5007: Unable to get value of the property '0': object is null or undefined

javascript internet-explorer-9 liferay-6 portal

I am uploading a picture in a portlet and have checked the size of the image - if greater than 5MB it is supposed to show an alert but in IE (precisely IE9) it does not show an alert insted throw m...