Hello,
I am trying to find a way to average out the start time and end time for a week long period. The only problem is, there can be multiple start and end times in one day depending on how jobs were done that day. So I need to average the earliest start time for each day and the latest end time for each day for the whole time period, for multiple employees.
I was able to work out the days worked, the times are the last piece that I need.
I have attached an example.
Thank you in advance!
Bookmarks