Recount after certain condition is met
Hi all, I'm trying to compute a certain formula but am unsure of how to do it. I want to employ a function which will recount from 0 if a condition is met. For example, Motor A reaches 25 ...
Forum Discussion
you may need to use a few date/time fields to get this correct, but I need more details.
When does Hours of Use begin calculating time, what does it base its total time off of as a start time?
Maintenance needs a date time also, as multiple maintenance events can occur.
var datetime Time = Max( [Start Time],[Maintenance Time])
tohours(Now()-$Time)
will provide a duration, you can set to hours as a number
tonumber(tohours(Now()-$Time) )
When Start time is 10 am, and it is now 11:15, the number of hours will be 1.
When the start time is 10 am, and it is now 11 am the next day, the number of hours will be 25.
When the Maintenance time is 12 pm, and it is now 1pm, the number of hours will be 1.
You can use form rules to set the start and maintenance time, but some action must set these date/time fields in order for this process and formula to work.
Let me know if this helps.
When does Hours of Use begin calculating time, what does it base its total time off of as a start time?
Maintenance needs a date time also, as multiple maintenance events can occur.
var datetime Time = Max( [Start Time],[Maintenance Time])
tohours(Now()-$Time)
will provide a duration, you can set to hours as a number
tonumber(tohours(Now()-$Time) )
When Start time is 10 am, and it is now 11:15, the number of hours will be 1.
When the start time is 10 am, and it is now 11 am the next day, the number of hours will be 25.
When the Maintenance time is 12 pm, and it is now 1pm, the number of hours will be 1.
You can use form rules to set the start and maintenance time, but some action must set these date/time fields in order for this process and formula to work.
Let me know if this helps.