Calculating average time

[slinky192001]

Hi,

I am trying to perform the following calculation in excel.

162690 seconds shown as Hours minutes and seconds and divided by 16.

I have enetered the following =162690/60/60/16. However this is giving me results in hours and fractions thereof (2.824479)

Is it possible for excel to calulate this in Hours minutes and seconds?

I've tried to make as much sense as possible apologies if this is a little confusing.

 

[Andrew Poulsom]

Try formatting the cell as [hh]:mm:ss.

 

[Richard Schollar]

Hi Clare

Need to divide by the hours too and then format the result as time:

=162690/(60*60*24*16)

Format to eg

[h]:mm:ss

Why do you divide by 16?

 

[slinky192001]

I divide by 16 as the calculation is basically 16 cases logged with a total fix time of 162690 seconds. So i need to find the average fix time per case.

Thank you for your help