Forum Discussion

jamescosten's avatar
jamescosten
Brass Contributor
Jun 19, 2024

Facility Check Time, Shift Time Check Calculated Column

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.

 

 

No RepliesBe the first to reply

Resources