Formula

[JoseGarcia]

Hi there, 
I have a formula that validates the time when completing a specific task.
When the task is less than 4 minutes, it triggers "Process not validated".
The issue I have is that some of the tasks happen from one day to another (nights). This is makes the formula not to give an accurate result.

See the picture to illustrate.

My question is how can I solve the date problem into my formula.

= if(signature_32> MakeTime(0,5), 'Validated', 'Process-NOT-Followed' )

[morgankejerhag]

Can the finish time be more than one day after? If it is either the same or the next day I guess you can mathematically change the finish time to one more day.

FinishTime+If(FinsihTime>StartTime, 1,0) as CalcFinishTime

[JoseGarcia]

Morgan, 
thanks for your support.
Time can only go over by one day.
This is where I am.
Created new dimension 'CalcFinishTime'
Update formula: 
if(CalcFinishTime> MakeTime(0,4), 'Validated', 'Process-NOT-Followed' )

It is validating times under 4 minutes.

where am I going wrong?

[morgankejerhag]

You have to compare the values also (or calculate the diff in the script):

if(CalcFinishTime-StartTime > MakeTime(0,4), 'Validated', 'Process-NOT-Followed' )

[JoseGarcia]

Morgan, 

used expression: 

=if(CalcFinishTime-StartTime> MakeTime(0,4), 'Validated', 'Process-NOT-Followed')

Could I have an issue my calcfinishtime on my script?

[morgankejerhag]

Yes, you can move that to the script so it is easy to show in the cart. The whole calculation of Process Validatet can probably be in the script and just be a field you show in the table. In this case the user can make selections on it as well.