How to calculate average time

Hi,

I would like to know how to calculate the average time. Attached please find a sample data. Column "Total Time taken" conatins the time for each and every transaction.

I would like to know the average time. Please help..

Regards,

Shane

If you know the end cell you could just use

=Average(H2:H10)

I assume the list will probably not always have 9 entries in it so you would want H10 to be variable. I'm not very good with worksheet formulas so haven't figured out how to do this, but will get back to you if I do before someone else can help.