I am trying to set up a time sheet that would look like this:
<tbody>
</tbody>
<tbody>
</tbody>
2-Jan | 3-Jan | 4-Jan | 5-Jan | 6-Jan | ||||||
6:00 AM | 12:00 PM | 6:00 AM | 4:00 PM | #VALUE! |
<tbody>
</tbody>
When I try and do a formula to have lunch taken out it breaks because I still do not completely understand what I am doing. I can take out lunch with =SUM(D29-C29-"00:30")+(F29-E29-"00:30")+(H29-G29-"00:30")+(J29-I29-"00:30")(L29-K29-"00:30") but I want to only subtract it on days that have more than 6 hours worked. I tried this one =SUM((D29-C29)*IF((D29-C29)>VALUE("6:00"),-"00:30"),"(D29-C29)") and it isnt working properly. Once I had this good I was going use it for each set of days in my SUM function to get total hours worked. Any assistance would be welcomed with open arms.<value("6:00"),-"00:30"),"(d28-c28)")< td=""></value("6:00"),-"00:30"),"(d28-c28)")<> | ||||||||||||
<tbody>
</tbody>