Hi,
I currently have to identify hours worked between 2 times of day from a very large set of timesheet data and in a few different iterations. I wanted to ask what the most efficient ) way to write the relevant Date/Time expression that would capture the hours associated with the following criteria:
Hours worked on a weekday prior to 7am and finishing after 9pm
Hours worked on a Saturday prior to 7am and finishing after 6pm
Hours worked on a Sunday prior to 9am and finishing after 6pm
While it seems a bit simple prima facie, I have to write over 50 Date/Time criteria, all in a similar fashion, hence wanting to ensure its the most optimised so I can potentially macro this later. Additionally, is there any way to write this that does not involve appending the time ranges above to each timesheet entry?
Sample data is attached.
