| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 ? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 ? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 ? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need formula for time between two events | Excel Worksheet Functions | |||
| Running Total for Time Spent for a project in 1 month | Excel Worksheet Functions | |||
| How can I calculate amount of time left based on amount spent? | Excel Worksheet Functions | |||
| How can I show time spent? | Excel Worksheet Functions | |||
| Funcation to average the Time spent | Excel Worksheet Functions | |||
Linear Mode
