I am working on a time sheet. The guys get a minimum of 56 hours every week they they work (7 day weeks) but we don't work every day so for example if we work 3 days, they get a 24 hour minimum. I'm trying to figure out how to work out an if then type line where if they have less than an 8 hour average for the days they work the total is adjusted to the 8 hour average. Any suggestions?
Bookmarks