How to extract the date and time from a serial date in Excel Your email has been sent ... Choose 1:30:55 PM from the Type list. Check out this article I found on TechRepublic.