Hi,

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?

Thanks

By: alex