Hi Guys, I am jsut writing a formula which I'd like to display either the word Yes, or No if a cell shows a value of higher than or less than 12 hours.
As you can see here in the image below, the formula works for the first value, in which over 12 hours has been worked, however the final value shows yes, even though only 6 hours has been worked.
https://imgur.com/9Rj0FHm
The current formula I am using is:
TIA
As you can see here in the image below, the formula works for the first value, in which over 12 hours has been worked, however the final value shows yes, even though only 6 hours has been worked.
https://imgur.com/9Rj0FHm
The current formula I am using is:
Code:
=IF(I3>TIME(12,0,0), "Yes", "No")TIA
