Averaging time
I have columns with data in the following formats:
Column A Column B Column C
12/7/2004 2:00:00 PM 3:51:00 12/7/2004 5:51:00 PM
B1 being =C1-A1 and ColB being formatted to HH:MM:SS using time value.
I then want an average of the time values in all of ColB. Somewhere the
logic breaks if I try to do =AVG(B1:B255) though.
Kat
|