I am trying to make a time sheet for my office
If employees work over 8 hours, they can get hourly credit towards extra time off (up to one hour, per day)
I am trying to add up the times that employees work extra and cap it at 1 hour in the formula, even if it is over 1 hour. So someone might work 2 extra hours one day and 1 extra hour 4 days, but it should only be 5 hours total credit that they get.
So cells d7, f7, h7, j7 and L7 need to equal up but only allowing 1 hour, per cell
Bookmarks