Hello,
I'm having trouble with conditionals based on a primarily a 4 hour minimum. I am trying to set it up so that anything under 4 is shown as the minimum 4 hours + Travel Time - Lunch Time or if it is greater than 4, shown as Regular Hours + Travel Time (since travel cannot be overtime) - Lunch Time & Overtime (anything over 8 hours). Additionally, I was wondering if it would be possible to incorporate an additional IF formula based on the date. If the entered date is on a weekend, then all hours worked will need to be overtime rather than regular. If this is not possible, then do not mind. Any help would be appreciated. Thanks!
Bookmarks