Averaging Time
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 |
Averaging Time
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 |
All times are GMT +1. The time now is 12:59 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com