Using the Value of IF

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

 

Time In Lunch Out Lunch In Time Out Worked Hours Lunch Hour Volunteer Hours Paid Hours
9:00 12:00 13:00 16:00 7:00 1:00 1:00 5:00

By: alex

Leave a Reply

Your email address will not be published. Required fields are marked *