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.

​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.    Read More

​