Hello all,

I am having one heck of a time figuring out why I am running into issues with these relatively basic time cells. So I have made a fuel calclator for our flights in the F-18. It builds a "fuel ladder" starting from our land time working backwards every 15 minutes =F10-TIME(0,15,0) with the associated fuel state you should be at next to it. I have some conditional formatting to make the cells turn green if the time matches your Takeoff time inputted on another cell, as well as a formula that will add gas to the state if the time matches an airborne refueling time also entered on another cell. The conditional formatting and the formulas all work fine except for a few of the rows. For the life of me I cannot figure it out as they have idential formulas and are all formatted in the same way. If I manually enter the time directly in the cell (eg. D4=14:00 vice D4=D5+TIME(0,15,0) it will work! Again, this is only on specific times and not the specific cells.

I have made a simple test without most of the funtionality of my working document and running into the same issue. For whatever reason the highlighted times are not showing up as matching their adjacent manually entered time on the left. Ref. images

Any help is greatly appreciated!

Thank you!!!
TEST_CELL.jpg
TEST_CELL2.jpg
TEST_CELL3.jpg
TEST_CELL4.jpg