Report Offensive Message

Hi Simon,
To elaborate the same we need to understand the numerical equivalant of TRUE & FALSE.
In Excel TRUE represents Number 1, & FALSE represents number 0.
Thus if the difference between 2 timings are negative ($B2>$C2) gives result as TRUE, i.e. 1 and gets added in the negative value, as this negative value is always less than 1, the entire result turns to a positive value.
This means 8:00 AM - 10:00 PM gives value as -0.583333333 (in general format / Julian number format). This turns to (-0.583333333 + 1 = 0.416666667) means 10:00 Hrs.

Regards,
Yogi