Greetings. I need help with the conditional format of calculations. Time formats are in 24 hours (hh:mm). How can I conditional format wrong calculations (Third row calculated wrongly) and true calculations (1,2,4th row true). Thank you for your time. ( For an example just wanted to 3rd column [Duration] Green if correct, Red if wrong calculation)
Kitap1 | |||||
---|---|---|---|---|---|
A | B | C | |||
1 | Departure | Arrival | Duration | ||
2 | 11:00 | 13:00 | 02:00 | ||
3 | 23:10 | 01:00 | 01:50 | ||
4 | 10:50 | 12:50 | 03:00 | ||
5 | 08:00 | 10:00 | 02:00 | ||
Sayfa1 |