Can Excel recognize 2400 hours as midnight today? Every formula I try forces
the date/time to show it as 1st thing tomorrow morning. ie, it adds one day
to the date, when it should not do so until 0001 hours.

Thanks in advance.

TBF