Hello All! I am trying to make an employee c...

(Jacob hall) #1

Hello All!

I am trying to make an employee clock in/out app. I’m trying to make it where the employee can give a reason why they are late if they clock in late, but I’m having trouble with the SHOW_IF formula.

=IFS([Time In]>“08:30:00”, [Clock In] = “Clock In”)

When I put the date time in as “08:30:00” it shows in verify as “12/30/1899 08:30:00 AM”

The [Clock In] is an enum with the only value of “Clock In” The [Time In] is a ChangeTimestamp type Column that activates when someone hits “Clock In”

I’ve tried adding (TODAY()+“08:30:00”) and some other alternatives but they don’t seem to work. Can anyone help?

(Aleksi Alkio) #2

AND(HOUR([TIME IN] - TODAY())+MINUTE([TIME IN] -

TODAY())/60.0>8.5,[CLOCK IN] =“CLOCK IN”) should do the trick. You can’t evaluate time and datetime correctly without the date value.