| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
AVARAGE TIME
HOW TO GET AVARAGE TO THE FOLLOWING
DD:HH:MM:SS 01:12:15:10 00:07:18:00 00:01:25:10 PL ADVISE ANY ONE HOW TO GET AVARAGE TIME OF THE THREE TIMEINGS THANKS -- gv |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
AVARAGE TIME
Assuming the below
A1:A10 = Start Date B1:B10 = End Date C1 with the formula (=B1-A1) custom formatted with dd:hh:mm:ss the average would be =AVERAGE(C1:C10) If this post helps click Yes --------------- Jacob Skaria "raogv" wrote: HOW TO GET AVARAGE TO THE FOLLOWING DD:HH:MM:SS 01:12:15:10 00:07:18:00 00:01:25:10 PL ADVISE ANY ONE HOW TO GET AVARAGE TIME OF THE THREE TIMEINGS THANKS -- gv |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| straight time, time and a half, and double time | Excel Discussion (Misc queries) | |||
| Calculate Ending time using Start Time and Elapsed Time | Excel Worksheet Functions | |||
| Dynamic Avarage | Excel Worksheet Functions | |||
| Make a formula to calculate the avarage of baseball stats | Excel Worksheet Functions | |||
| Calculating days & time left from start date/time to end date/time | Excel Worksheet Functions | |||
Linear Mode
