The universal date format is #yyyy-mm-dd hh:mm:ss#. However, both the date component ( #yyyy-mm-dd#) and the time component ( #hh:mm:ss#) can be represented separately.
Excel Glossary
The universal date format is #yyyy-mm-dd hh:mm:ss#. However, both the date component ( #yyyy-mm-dd#) and the time component ( #hh:mm:ss#) can be represented separately.