I am trying to average out the handle time of a list of reps. I have the
times already in the cells for the past week. I just need to know how to
write the formula. The times are shown as follows 0:4:34 (day1), 0:5:36
(Day2), 0:7:12(day3). the time is HH:MM:SS.

Please help

with:

0:04:34
0:05:36
0:07:12
in A1 thru A3

=AVERAGE(A1:A3)

will display:

0:05:47

with the same format
--
Gary''s Student - gsnu200728


"Keit" wrote:

I am trying to average out the handle time of a list of reps. I have the
times already in the cells for the past week. I just need to know how to
write the formula. The times are shown as follows 0:4:34 (day1), 0:5:36
(Day2), 0:7:12(day3). the time is HH:MM:SS.

Please help