trigger an auto timer

I am trying to set up a Downtime Tracker. 

I have a cell that changes from 0 to 1 this is changing based on a PLC sending info if the machine is running or not. 

O = machine is running

1 = machine is stopped

I need a timer that when 0 changes to 1 there is a 1 min delay before starting the actual timer and once the 1 changes back to 0 the timer stops and the hr:mm:ss is added into the DT Mins field. 

0 2 121
2 REPLIES 2

There is no capability to run a timer in AppSheet.

What you can do is set a Start Time when 0 to 1, set a Stop Time when back to zero then compute the difference to get elapsed time.

Yes that would work. Thank you. To make the 1 minute delay i would need to have a third variable so  like 0- running 1- down for less than a minute 2- Machine is down Now Start Time back to 0 stop time then get the elapsed time.  I will give it a shot thank you again for the help.

Top Labels in this Space