So im trying to build the timesheet below.
I need the times worked. but i also need there to be one volunteer hour if the worked hour is 7 or more. The paid option should just be the worked hours minus lunch and volunteer hour.
The tricky part is the time out can never pass 16:00, but i need 1 hour for lunch. If the person works past 16:00, everything from then on is volunteer hours. I need a formula to display that information.
The final bit is to take the worked hours and subtract it from the lunch and volunteer hours.
How should i write the formulas for the volunteer and paid hours since they are so dependent on the volunteer hours section?