Averaging Time

G

Guest

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
 
G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top