... again, there is no need to do anything with a formula.

Irrespective of how your cell is formatted it contains a number like 41802.49.

You can choose to format it to show either the date (the integer part) as in your original question, or the time (the decimal part) - with a "hh:mm:ss" format.