Average time spent to # of events
 

How can I get an average of time by a number of events?
Example: I have spent 3:00 (formatted as [h]:mm)
on 9 events. How do I obtain an average ?

Average time spent to # of events
 

Hi Jennifer
try
=AVERAGE(B1:B9)

"Jennifer" wrote:

How can I get an average of time by a number of events?
Example: I have spent 3:00 (formatted as [h]:mm)
on 9 events. How do I obtain an average ?

Average time spent to # of events
 

if 3:00 is on A1 your formula in B1 =A1/9 formatted as time
--
If this posting was helpful, please click on the Yes button.
Regards,

Michael Arch.




"Jennifer" wrote:

How can I get an average of time by a number of events?
Example: I have spent 3:00 (formatted as [h]:mm)
on 9 events. How do I obtain an average ?