Hello All,

I am calculating time in "hours:minutes" from difference of dates e.g. CELL A1= 05.08.2017 10:00 CELL B1=05.08.2017 15:30, CELL C1=B1-A1.

Format A1 - Date, Format B1 - Date, Format C1 - Time [h]:mm .

As result C1= 5:30 .

I am writing in to the CELL D1 5:30, same format and value as C1.

Now in CELL E1 I am using function IF(D1=C1; "ok"; "fault") and I have as result "fault", means C1 not equal D1. In Formula Builder values are the same, but function does not work correctly.

What is the reason?

Thank You in advance for any suggestions.

Best Regards,
maro12