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.


--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Eán" wrote:

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