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.

 

jamescosten_0-1718799761151.png

 

0 Replies