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

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" <(E-Mail Removed)> wrote in message
news:ABDB1E6C-4698-4778-8908-(E-Mail Removed)...
> 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
>
>

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

"Eán" <(E-Mail Removed)> wrote in message
news:ABDB1E6C-4698-4778-8908-(E-Mail Removed)...
> 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
>
>

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