I have attached a spreadsheet with a formula which I cannot get to work.
cells in column B have a time already keyed in. E generates the time when the box in D is ticked. I then have a formula in cells in column G that say =IF(E2="","",IF(E2>B2,"Y",
But it does not return correct answer.
Appreciate any help with this