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

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

Formula:

=TIME(VALUE(LEFT(E18,2)),VALUE(RIGHT(E18,2)),)

, 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

Formula:

=TIME(18,30,)

BLUE

Left
time is coming from this formula

Formula:

=TEXT(N27,"00\:00"))

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


Right
time is coming from this formula

Formula:

=TIME(18,30,)

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