Forum Discussion
Night shift (logic, calculation)
Hi everybody, I'm looking for a solution, but I can't find it. I would like to know the time worked. Info: - People work in the morning, afternoon and night. Overtime is also possible. - Thousand...
Hi Krivger - part of your problem is that you are tying to calculate the difference based on TIME data type. You need to consider changing to DATETIME data type. Please consider the following example:
The Time Difference calculated column in the first row cannot calculate the difference because the Time does not recognise the change in date. When the DateTime is captured, the time difference is correctly calculated.
Hi.
Unfortunately, your answer is not good. Normally it would be good, but in this case it is not good.
Time has shifted.
1 day = (example) 2022.10.16 6:00:00 -> 2022.10.17 6:00:00 = 24 hours
I tried to subtract 6 hours, but it wasn't good either. If I look at it for a week, it's even worse. I have no idea 😞