Hi! I work at a call center. Part of my job involves identifying what managers are working and assigning them manager shifts. I created a set of manager shift slots with pre-defined start and end times within my python code.I am trying to create software that will take an Excel file that contains the name of employees and start and end times of their shifts and compares it against the start and end times of manager shift slots to see if there is an overlap. If there is overlap I want the code to print the name of the employee so I can assign them a manager shift. This is a picture of the code I have so far.
It will not work because the times in column C of the Excel sheet are datetime.time objects. I need to convert the datetime.time objects to datetime objects and then convert those to strings. This is the error code that I am getting back.
TypeError Traceback (most recent call last)
in <cell line: 12>()
13 if int(cell.row) > 1:
14 # Convert the value of the cell to a datetime object
—> 15 start_time_cell = str(datetime.strptime(cell.value, ‘%I:%M:%S %p’).time())
16
17
TypeError: strptime() argument 1 must be str, not datetime.time
Not sure if this is relevant but I am creating this in google colab. I have next to no coding experience and tried to use google bard to help me without luck. Any suggestions anyone has would be greatly appreciated! Thank you in advance!