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.

"Eán" wrote in message
...
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