Check Time greater or equals to in Sharepoint List

Copper Contributor

Hi All,

I created Lunch Check field to check if Action column is "Clock-In" and riTimeOnly column is equal or greater than 11:30:00 then the Lunch Check column should insert 0.5 if both condition is true. I am not getting the results correct therefore I need some expert advice what is wrong.

 

 

NSBSLYS_1-1647511209678.png

NSBSLYS_2-1647511269953.png

 

I am expecting the first 3 records to have 0.5 indicated.

NSBSLYS_3-1647511512578.png

 

 

 

0 Replies