Calculating Average Time

[Eán]

Hi

I have two columns one with a number of occurances and the other with a
duration of time hh:mm - formatted by /24/60.
I need to find a formula so I can show in a third column the average time
per occurance, so for example:

2 00:20
5 01:00

So the third column would show 00:10 and 00:20 respectively.

Many thanks

 

[Fred Smith]

Times are just numbers to Excel, so use:
=Average(a1:a100)

Adjust the range to suit. Use the same format as for your other times.

Regards,
Fred.

 

[David Biddulph]

=B1/A1 and format appropriately, but where do you get the 00:20? Isn't it
00:12?

 

[Shane Devenshire]

Hi,

Suppose these are in A1:B2, in C1 enter the formula

=A1/B1

Now remember that 1:00 is a time of 1 hour, if you divide that by 5 you are
returning 1/5 of an hour which is not 20 minutes but 12 minutes.