Time calculation based on formula, which make different result, Simple yet confusing, Help

[radian89]

Hi All,

FORUM.JPG

Based on this picture above, I want to ask how could this happened? here's the detail :

GREEN

Left
time is coming from this formula

Please Login or Register  to view this content.

, which for some reason, I used this formula because the data given/downloaded, couldn't be presented as time (they're as text).


Right
time is coming from this formula

Please Login or Register  to view this content.

BLUE

Left
time is coming from this formula

Please Login or Register  to view this content.

, which N27, from a user input for using military time format, for ease of input.


Right
time is coming from this formula

Please Login or Register  to view this content.

and the true false criteria, is Left > = Right, it should present in FALSE yet, the blue said TRUE, how could this happened? any suggestion?

thanks a lot for the help,
warm regards

Adrian

[Jean.P28]

16:45 and 14:00 is text