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 | |||||
