Forum Discussion
Solved
Formula for Timesheets using IF THEN Scenario
I would like to create a formula in timesheets which calculates the total hours worked less the break time taken and if the "Break" column is No then the total hours will be from start time to finish...
Any help for this?
| DATE | WORKING HOURS | HOURS | ||||||
| START TIME | ON SITE | OFF SITE | FINISH TIME | STD HOURS | x1.5 | x2 | TOTAL | |
| 14/02/2022 | 07:40 | 09:00 | 17:15 | 19:00 | ||||
| 15/02/2022 | 07:10 | 08:45 | 15:40 | 17:15 | ||||
| 16/02/2022 | 05:00 | 06:00 | 17:30 | 19:00 | ||||
| 17/02/2022 | 07:30 | 09:15 | 17:00 | 17:40 | ||||
| 18/02/2022 | 06:30 | 08:00 | 16:00 | 17:00 | ||||
| TOTAL HOURS | 0 | 0 | 0 | 0 | ||||