| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Average time
I have one column with time values in 24hr clock format (1742,812,1314,etc)
without colons. I can convert the times to a 12 hour clock and add the colon but I would prefer not to. I need to calculate the average time of the column. Suggestions? I have tried the average function which returns an incorrect value. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Average of Day and Time | Excel Worksheet Functions | |||
| Average Time | Excel Worksheet Functions | |||
| average rate of change per given time period between 2 moments in time of a value | Excel Worksheet Functions | |||
| Finding the average time | Excel Worksheet Functions | |||
| Average Time | Excel Worksheet Functions | |||
Threaded Mode
