time calculations

  • Thread starter Thread starter Karen Foster
  • Start date Start date
K

Karen Foster

I need use hours:min:sec to calculate avg. calls/hour. I
have set up fields for Calls in 37:30:00 format and have
Total Calls in General Number format. I would think it
would be simple calculation for instanct of =Product
(A1/A6). However this isn't working. Do I need to set up
as *24 to make calculation work? My function is actually
more like: =product(A1-(A12+A13))/A6). HELP!
 
Hi Karen!

Total time of calls in A1:
37:30:00

Total calls in A6
20

Average call length:
=A1/A6
Returns: 1:52:30
Formatted as time [hh]:mm:ss

From which we deduce that there are teenagers in the house!

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Yes but you don't need product
total hours in A6 and total calls in A1

=A1/(A6*24)

maybe round?

=ROUND(A1/(A6*24),2)
 
And don't forget to format as General, after you entered the formula.
Formatting before that will not help.

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel
 
Back
Top