Forum Discussion
chris_may
Apr 08, 2023Copper Contributor
missing time calculations
hi
I have a "missing time" issue. I am inputting start time, finish time, and then missing time. the work sessions are 4hrs and I need to have the missed times from the 4hrs. I have the calculation to get the missing time but if there has been no start/finish times inputted then I have the 4hrs left in the column. from that column I am totalling the missing hours on a summary page, so, if there has been no start/finish inputs I need them to read 0.
normal session | 04:00 | |
start | finish | not worked |
10:00 | 12:00 | 2:00 |
11:00 | 14:00 | 1:00 |
4:00 |