On Apr 3, 3:02*pm, CR3 wrote:
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

Multiply all these values by 24 to see how many 24ths of a day they
comprise. Average those products and you'll get your answer.

I get an average of 9:12 PM, not 11:45 PM.

Dave