Convert date from excel in number format to date format python [duplicate]

by 
from datetime import datetime
excel_date = 42139
dt = datetime.fromordinal(datetime(1900, 1, 1).toordinal() + excel_date - 2)
tt = dt.timetuple()
print(dt)
print(tt)

As mentioned by J.F. Sebastian, this answer only works for any date after 1900/03/01

EDIT: (in answer to @R.K)

If your excel_date is a float number, use this code:

from datetime import datetime

def floatHourToTime(fh):
    hours, hourSeconds = divmod(fh, 1)
    minutes, seconds = divmod(hourSeconds * 60, 1)
    return (
        int(hours),
        int(minutes),
        int(seconds * 60),
    )

excel_date = 42139.23213
dt = datetime.fromordinal(datetime(1900, 1, 1).toordinal() + int(excel_date) - 2)
hour, minute, second = floatHourToTime(excel_date % 1)
dt = dt.replace(hour=hour, minute=minute, second=second)

print(dt)
assert str(dt) == "2015-05-15 00:13:55"

More Related Contents:

  1. Convert Excel style date with pandas
  2. How do I read a date in Excel format in Python?
  3. Pandas: Looking up the list of sheets in an excel file
  4. python xlrd unsupported format, or corrupt file.
  5. How to convert a python datetime.datetime to excel serial date number
  6. Reading Excel File using Python, how do I get the values of a specific column with indicated column name?
  7. Get formula from Excel cell with python xlrd
  8. Error: Unsupported format, or corrupt file: Expected BOF record
  9. How to obtain sheet names from XLS files without loading the whole file?
  10. Leave dates as strings using read_excel function from pandas in python
  11. Insert row into Excel spreadsheet using openpyxl in Python
  12. Edit existing excel workbooks and sheets with xlrd and xlwt
  13. Identifying Excel Sheet cell color code using XLRD package
  14. Iterating through a range of dates in Python
  15. Combine Date and Time columns using python pandas
  16. Parsing date with timezone from an email?
  17. How to increment datetime by custom months in python without using library [duplicate]
  18. Can’t subtract offset-naive and offset-aware datetimes
  19. Convert datetime to Unix timestamp and convert it back in python
  20. Running an Excel macro via Python?
  21. Datetime Timezone conversion using pytz
  22. How to read datetime back from sqlite as a datetime instead of string in Python?
  23. Fetching datetime from float in Python
  24. Refresh Excel External Data with Python
  25. Subtract a year from a datetime column in pandas
  26. How to convert epoch time with nanoseconds to human-readable?
  27. Formatting “yesterday’s” date in python
  28. Python strptime parsing year without century: assume prior to this year?
  29. Pandas datetimes with different formats in the same column
  30. How to return and download Excel file using FastAPI?

Leave a Comment