| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
Funcation to average the Time spent
Hi,
I am unable to get the right function to find the average time of 10 cells The time is in dd:hh:mm format,like 0:0:03. Any help in this regard is higly appreciated Regds Subbu |
|
#2
|
|||
|
|||
|
=AVERAGE(A1:A10) and format as time
-- HTH RP (remove nothere from the email address if mailing direct) "subbu" wrote in message ... Hi, I am unable to get the right function to find the average time of 10 cells The time is in dd:hh:mm format,like 0:0:03. Any help in this regard is higly appreciated Regds Subbu |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| entering numbers to display a time format | Excel Discussion (Misc queries) | |||
| Help - Information with time and date | Excel Discussion (Misc queries) | |||
| calculate negative or positve difference in time | Excel Discussion (Misc queries) | |||
| calculate average hours worked | Excel Worksheet Functions | |||
| time formatting and time categorizing (vlookup or data validation) | Excel Worksheet Functions | |||
Hybrid Mode
