Alexandra Kanik akanik
OmarArain
/ xldate_to_datetime.py
Created
April 3, 2014 17:48
convert Excel serial date to python datetime.datetime
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| import datetime | |
| def xldate_to_datetime(xldate): | |
| temp = datetime.datetime(1900, 1, 1) | |
| delta = datetime.timedelta(days=xldate) | |
| return temp+delta |