Exceljet

Quick, clean, and to the point

Excel datetime

Excel datetimes include both date and time values

In Excel's date system, dates are serial numbers and times are fractional parts of one day. When a value contains both a date and a time together, it is sometimes called a "datetime". For example, the date November 2, 2021 corresponds to the serial number 44502. If we create this date with the DATE function, it returns 44502:

=DATE(2021,11,2) // returns 44502

When a date format is applied to this value in a cell, the number 44502 can be displayed as "November 2, 2021", "2-Nov-21", etc.

If the number is instead 44502.5, it is called a "datetime" because it contains both a date and time. This is equivalent to the following formula:

=DATE(2021,11,2)+TIME(12,0,0) // returns 44502.5

If a date format that includes time is applied to a cell with that contains 44502.5, the value can be displayed as "November 2, 2021 12:00", "Nov 2 12:00 PM", etc.

In short, any date serial number that includes a decimal value can be considered a datetime.