| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Adding time [t]:mm:ss
Hi.
I try to figure out the average time spent in a range but cant figure out how. This is how it looks like: 00:00:10 00:00:06 00:00:00 00:00:04 00:00:04 ------------ =AVERAGE(A2:A6) =============== Here is a total of 24 seconds. These seconds should be divided with 4 and return the answer; 00:00:06. The problem is: 1) One row does not contain any hours, minutes or seconds and should not be counted. 2) Even when there is no figures in that particular row, the answer returned is wrong? Anybody have a suggestion? Thanks in advance for your help! Jan |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Adding numbers to a Time Formated cell | Excel Discussion (Misc queries) | |||
| Adding time | Excel Worksheet Functions | |||
| what is the formula for adding up time intervals? | Excel Discussion (Misc queries) | |||
| Adding time | New Users to Excel | |||
| adding in time formats | Excel Discussion (Misc queries) | |||
Threaded Mode
