To get the nearest time (and date) in the future from NOW(), in any cell in your sheet this array-entered formula:
(array-entered means Ctrl+Shift+Enter while committing the formula to the sheet, NOT just Enter)
... still reading ... or try to read ... 'nearest deadline' NOW it is 22:30 then nearest dealine would be 03:30 AM Yes - No - - - now isn't 22:30 or not or it could be current time, who knows?
... then 'deadline' won't necessary to be 03:30 AM ... it current time isn't 22:30.
Please, try next time write 'what do You would like to get?'
with clear logic ...
Having nicked your workbook I at least did you the courtesy of using the infrastructure you had set up ! Because I treat direct references as qualitative errors, I simply applied the name 'Now' to the cell.