Parsing excel timestamp format with Python

excel_series_to_datetime.py

EXCEL_TIME = 42607.5234143519

# way 1
import datetime
def xldate_as_datetime(xldate, datemode):
    # datemode: 0 for 1900-based, 1 for 1904-based
    return (
        datetime.datetime(1899, 12, 30)
        + datetime.timedelta(days=xldate + 1462 * datemode)
    )
way_1_res = xldate_as_datetime(EXCEL_TIME, 0)  # datemode 0
  
# way 2
import xlrd
way_2_res = xlrd.xldate_as_tuple(42607.5234143519, 0)  # datemode 0


# way 3 (PROBABLY BEST ONE)
import pandas as pd
way_3_res = pd.to_datetime('1899-12-30') + pd.to_timedelta(EXCEL_TIME, 'D')