Using three Microsoft Excel functions, you can easily parse time components from a full date value.

How to add helpful prompts to Microsoft Excel cells Enhance your spreadsheets by providing on-the-spot instructions.