Oct 21 2021 03:26 PM
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 time. Please see example below.
Oct 21 2021 04:02 PM
SolutionOct 21 2021 04:28 PM
Thanks @Sergei Baklan that has worked.
Feb 27 2022 03:33 PM
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 | ||||
Oct 21 2021 04:02 PM
Solution