Hi,
We have a situation where we need to find "number of hours" spent by each employee on "a particular date" but in between "a fixed interval".
Fixed Interval - Daily from 7:30 AM to 4:30 PM
We have list of employees and dates for the data.
Shifts can spillover several days, so solution...