I'm looking for a way to set up a calculated field for the number of hours logged during a set period of time (between two dates that I'd like to hard code) within a project. I'm getting hung up on combining an if statement to limit by entry date with a sum statement that totals the hours that quali...

We have a group of video editors who have fairly irregular schedules. They can work up to 5 days a week on any combination of Monday to Sunday and either morning or evening shifts on those days. Random example:M T W T F S S9-5 | off | 9-5 | 4-12 | off | off | 9-5 While we...