What is wrong with this expression?

[hopkinsc]

Hi all, i have attached a sample file where i am getting an issue with an expression.

The expression should be summing the OrderComplete_Flag where the [Time Taken to Complete] is less than 4hrs.

the result i get should be 3 but i am getting 6 and i am unsure on why.

the expression is saying that 3 of the times are less than 4 hrs but they are not.

Can anyone help please?

[#2]

=sum(if(Interval([Time Taken to Complete],'hhh')>=4,1,0))

[hopkinsc]

Hi, Sorry, i have just noticed that your expression says greater or equal to 4. i need it less than 4 but when i do that i get the wrong result.

[#4 · Accepted solution]

=sum(if(SubField([Time Taken to Complete],':',1)<4,1,0))

[hopkinsc]

thats great thanks very much..

One more question,

how would i get a time range in there?

eg

it is currently set at <4 hrs, but what if i wanted >1hr <24hrs?

[#6]

=sum(if(SubField([Time Taken to Complete],':',1)>1 AND SubField([Time Taken to Complete],':',1)<24,1,0))