Average of TOD (Time Of Day) Entries

  • Thread starter Thread starter GBL
  • Start date Start date
G

GBL

Hi:
Am in need of a formula to determine the average of many military TOD
(Time Of Day) entries. These cells are in text format and are expressed as
military time as in: 17:46, 17:32, 18:03, 17:23... etc. These are all of
five character length.
A prior post gave me info on conversion tips, but I still cannot grasp
the secret(s). Please remember, I'm not in need of a total; but an
average. I've tried converting each entry into minutes from 00:00 and
dividing by 60 to get hours, but I get lost after that.

Thanks in Advance!!
 
GBL,

if indeed they are times formatted as hh:mm you can use the average function
like

=AVERAGE(A2:A20)

format result as time
 
Hi:

If you also want the average in text format, try:

=TEXT(AVERAGE(TIMEVALUE(A1:A4)),"hh:mm")

entered as an array formula with <Ctrl><Shift><Enter>. It should look like
this (the curly braces are automatically inserted by Excel):

{=TEXT(AVERAGE(TIMEVALUE(A1:A4)),"hh:mm")}

Regards,

Vasant.
 
=AVERAGE(A1:A4*1)

Array-entered (meaning press ctrl/shift/enter).

HTH
Jason
Atlanta, GA
 
Hi:
Thanks for your help! It works!!


=AVERAGE(A1:A4*1)

Array-entered (meaning press ctrl/shift/enter).

HTH
Jason
Atlanta, GA
 
Back
Top