The way dates and times are typically formatted are not how they are actually stored in a spreadsheet. This video describes the way that Excel uses “serial numbers” for dates and times.