time calculations

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

 

[Norman Harker]

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.

 

[Peo Sjoblom]

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)

 

[Niek Otten]

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