Thread: Average time spent to # of events
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Eduardo Eduardo is offline
external usenet poster
  
Posts: 2,276
Default 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 ?
Reply With QuoteReply With Quote