I have a question about averaging specific time events when times span midnight.
I am required to track the times computer files are uploaded to clients. I was asked to provide weekly averages by shift. For our second shift, approximately 20% of the upload times occur before midnight. During the course of a week, there is an average of 500 data points. The data is electronically mined out of our computer system. Below is a small sampling:
1/7/2005 23:16
1/7/2005 23:54
1/7/2005 23:54
1/8/2005 0:18
1/8/2005 0:24
1/8/2005 3:00
1/8/2005 3:00
1/10/2005 2:10
1/10/2005 3:11
1/10/2005 3:11
1/10/2005 3:11
What is wanted is the average TIME, the date is completely arbitrary. The average of the above data is 01/08/05 19:02. If I average just the time, I get 08:08. If I manually alter the dates so all the times between 00:00 and and 04:00 (in this case) are today’s date and all uploads greater than 20:00 hours are yesterday’s date, I get the correct average of 01:35.
Is there any way to calculate the average time without manually altering the dates, especially considering I am dealing with 500 data points per week?
Thanks,
I am required to track the times computer files are uploaded to clients. I was asked to provide weekly averages by shift. For our second shift, approximately 20% of the upload times occur before midnight. During the course of a week, there is an average of 500 data points. The data is electronically mined out of our computer system. Below is a small sampling:
1/7/2005 23:16
1/7/2005 23:54
1/7/2005 23:54
1/8/2005 0:18
1/8/2005 0:24
1/8/2005 3:00
1/8/2005 3:00
1/10/2005 2:10
1/10/2005 3:11
1/10/2005 3:11
1/10/2005 3:11
What is wanted is the average TIME, the date is completely arbitrary. The average of the above data is 01/08/05 19:02. If I average just the time, I get 08:08. If I manually alter the dates so all the times between 00:00 and and 04:00 (in this case) are today’s date and all uploads greater than 20:00 hours are yesterday’s date, I get the correct average of 01:35.
Is there any way to calculate the average time without manually altering the dates, especially considering I am dealing with 500 data points per week?
Thanks,