I am trying to compare a date and time to an date and hour slot. When comparing With floor they are not the same although appear the same
I am trying to compare a date and time to an date and hour slot. Eg, comparing a time of A
1
A 14/04/2023 15:20
B 14/04/2023 15:00
I was using if A1<=B1, but when there are minutes as in this example it misses it out, so I used floor(A1,"1:00")<-B1 and it is still not working.
If I look at value of each they l0ok that same, but subtracting they are not and logicall they are not. What is going on
Cells example
Formulas example
