Marinho

How to create vba code to monitor equipment functioning on / off?

Discussion created by Marinho on Mar 28, 2020

good afternoon guys!


I'm trying develop a display of horimeter that calculate the quantite of hours that equipament its working, wiht script VBA, there is possible get data of variables tha alternate in the value state, example on / off, of a specific date and perform the calculation from a defined date.

I say for the fact that if you close the processbook the decrease in hours will stop and the count will be out of normal!
I need to increase vba because there are many tags, and that would double the use of them.

 

hug!

Outcomes