Why can't you use:
Formula: copy to clipboard
=A1-NOW()


As for midnight crossover - how will you know if 17:23 is today or the next/previous day?

Will the difference to be calculated always be less than 24 hours?