View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
CR3 CR3 is offline
external usenet poster
 
Posts: 4
Default 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