Facility Check Time, Shift Time Check Calculated Column

Brass Contributor

I have a facility check SP List that users, through Power apps log safety checks. They are to complete these checks on each shift and within 1 hour of the shift starting.


I need a calculated column that can look at the the Shift Value and the Time it was logged and change a value in the Calculated column to Say Pass / Fail.


So as an example if the AM shift starts at 06:55:00 then the target time for the check is 07:55:00. 


IF (AM - Shift Time>07:55:00,"Fail", "Pass)


Can this be converted to a calculated column, as well as looking up the multiple shift values?


The last column in my excel example is the time over the target time.




0 Replies