Trouble to subtract minutes

[Anonymous]

Hi everybody,

I have the column "MargemEntrada" with the calculations

I subtract  "Batida1" -  'Escala Entrada"

When the difference is more than 00:05 Minutes, i want 1 with return, when the difference is less than 00:05 minutes i need blank.
But doesn´t work.

I have 00:05 with difference, in one line have 1 with result in another line have blank.

Here the "Margem"

Anyone know what´s the problem ?

[v-yanjiang-msft · Accepted solution]

Hi @Anonymous ,

According to your description, I create a sample, you can use MINITE function to calculate.

Best Regards,
Community Support Team _ kalyj

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Anonymous , a new column

column =

var _1 = [Batida1] - [Escala Entrada]

return

if(_1 > time(0,5,0) ,1,blank()

[Anonymous]

Doesn´t work

Happened the same 

Line with 00:05 difference, return 1.