time correction

Hi

I do not know when I made mistake but I can sort this out in the way I imagine.
Let me explain a problem:
I am import data from other system, like in cols A:C in attached file.
Problem is that everything reported after midnight I cannot recognise as next day due to the fact that it is only time. So, as You can see in col. M I will correct time with IF to get data as I want to.
When I put similar IF in formula in G2:

Formula:

Please Login or Register  to view this content.

result is not as expected.
I do not where is a problem.

Try this:

=LET(MyData,FILTER($A:$C,$A:$A<>""),xTime,CHOOSECOLS(MyData,2),xCorrdT,BYROW(xTime,LAMBDA(r,IF(AND(r>0,r<0.25),r+1,r))),HSTACK(MyData,xCorrdT))

Or, a slightly simpler approach:

=LET(MyData,FILTER($A:$C,$A:$A<>""),xTime,CHOOSECOLS(MyData,2),xCorrdT,xTime+(((xTime>0)*(xTime<0.25))),HSTACK(MyData,xCorrdT))

Your original was breaking down and returning a single value and not an array at this point.

Originally Posted by Glenn Kennedy

Your original was breaking down and returning a single value and not an array at this point.

That was a reason.

Thank You all.