Averaging the earliest start times and latest end times for multiple days

[kbiro]

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!