Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
MEAN in Military Time
I have the following military times in a column.
0:10 1:00 22:05 23:05 23:05 I am trying to take the AVERAGE of the times. I am getting 13:53 as the average time. However, this is incorrect. The actual average should be 23:45 in military time (corresponding to 11:45 pm.) How do I come up with this in Excel? Thank You. CR3 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Converting Standard Time to Military Time in Excel | Excel Discussion (Misc queries) | |||
formula for converting military time to standard time, etc | Excel Discussion (Misc queries) | |||
Converting Standard Time into Military Time | Excel Discussion (Misc queries) | |||
How to keep 0 for military time | Excel Discussion (Misc queries) | |||
Show timesheet time in and out in regular time versus military tim | Excel Worksheet Functions |