Very simple time sheet question for a formula that says “if the value inthis cell >8, then put the answer to value-8. If the value is <8, just put the value 0 in this cell “
So, my time sheet looks like this:
<tbody>
</tbody>6.75. 16.00 9.25. 1.25. 7.00
6.50. 12.50. 6.00. 2.00. 5.00
I want the OT field to auto calculate if I worked more than 8 hrs, how many more? And if I worked less than 8 hrs then just put 0. If you really want to get fancy, we could say if OT = 0, then 8-hours= how much time I need to make up and then subtract that amount from Cumulative OT. Please and thank you.
So, my time sheet looks like this:
In | out | Hours | OT | OTusedForMakeUpTime | CumulativeOT |
7.00 | 20.75 | 13.75 | 5.75 | 5.75 |
<tbody>
</tbody>
6.50. 12.50. 6.00. 2.00. 5.00
I want the OT field to auto calculate if I worked more than 8 hrs, how many more? And if I worked less than 8 hrs then just put 0. If you really want to get fancy, we could say if OT = 0, then 8-hours= how much time I need to make up and then subtract that amount from Cumulative OT. Please and thank you.