I have two expressions, one for Time In and one for Time out.
- If([Status]=“Absent without leave”,“00:00:00”,“08:00:00”)
The first one returns Zero
When I select Absent without leave?
- If([Status]=“Absent without leave”,“00:00:00”,“16:30:00”)
The second one is returning the current time, almost as if I had TIMENOW() expression and not the 00:00:00 I expected it to.
I also just checked in the Google sheet it is reporting to and when I synch it initially enters 00:00:00 for a couple of seconds in the column and then it changes to the current time. I’ve done it three times and it does it every time.
Any ideas why?