Using datetime in Python and how to import from Excel

Question

In python, I am using the command start = datetime.datetime.strptime(a, '%Y-%m-%d %H:%M:%S') and in Excel I have the date and time as 11/11/2005 12:00:00 AM. When I try to run the code, it is telling me that the time in excel does not match the code. How do I fix this?

%H is for a 24-hour clock and you are passing with an AM/PM. Change to ''%Y-%m-%d %I:%M:%S %p'. %I handles the 12-hour clock and %p handles the AM/PM. — Steven Rumbalski
– Steven Rumbalski, Commented May 22, 2018 at 16:07
Show some sample code. See the minimal reproducible example guidelines. In Excel, a time is a floating point value indicating the number of days since the epoch, so depending on how you fetch the Excel value you might be comparing a string to an float. — Mark Tolonen
– Mark Tolonen, Commented May 22, 2018 at 16:10

Rakesh · Accepted Answer · 2018-05-22 16:07:10Z

1

Your string representation of your date is a little wrong.

Try:

import datetime
a = "11/11/2005 12:00:00 AM"
start = datetime.datetime.strptime(a, '%d/%m/%Y %H:%M:%S %p')
print(start)

Output:

2005-11-11 12:00:00

answered May 22, 2018 at 16:07

Rakesh

82.9k17 gold badges85 silver badges122 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Vityata · Accepted Answer · 2018-05-22 16:30:28Z

1

This is what I have managed to get:

With this code:

import xlsxwriter
import datetime

workbook = xlsxwriter.Workbook('myxls.xlsx')
starting = datetime.datetime.now().strftime('%Y-%m-%d %H:%M:%S')
worksheet = workbook.add_worksheet()
worksheet.write('A1',starting)

answered May 22, 2018 at 16:30

Vityata

43.8k10 gold badges64 silver badges110 bronze badges

Collectives™ on Stack Overflow

Using datetime in Python and how to import from Excel

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related