String to time conversion error in Python 3.x

Question

I have certain time values in excel as :

Data:

932    
1253    
5

Coversions:

When trying to process them as a time string I get:

TIME_FMT= "%H%M"

datetime.strptime('932',TIME_FMT).time()
# Output : datetime.time(9, 32)

datetime.strptime('1253',TIME_FMT).time()
# Output : datetime.time(12, 53)

datetime.strptime('5',TIME_FMT).time()
# Output : ValueError: time data '5' does not match format '%H%M'

How can I catch such exceptional values for normal processing?

I understand that 5 does not match the format "%H%M".

Community · Accepted Answer · 2020-06-20 09:12:55Z

1

If you add some leading '0's to the string, the conversion can proceed like:

Code:

def from_time_string(time_string):
    TIME_FMT = "%H%M"
    leading = '0' * (3 - len(time_string))
    return dt.datetime.strptime(leading + time_string, TIME_FMT).time()

Test Code:

for i in ('932', '1253', '5'):
    print(from_time_string(i))

Results:

09:32:00
12:53:00
00:05:00

edited Jun 20, 2020 at 9:12

CommunityBot

11 silver badge

answered Feb 4, 2018 at 20:07

Stephen Rauch♦

50.1k32 gold badges118 silver badges143 bronze badges

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

Collectives™ on Stack Overflow

String to time conversion error in Python 3.x

Data:

Coversions:

1 Answer 1

Code:

Test Code:

Results:

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

Data:

Coversions:

1 Answer 1

Code:

Test Code:

Results:

Comments

Your Answer

Sign up or log in

Post as a guest

Related