How do I turn a strng which represents time to a number in Python? Any built-in function?

Question

I have a list of string time stamps:

['08:29', '08:03', '00:00', '08:09', '08:13', '07:54', '07:30']

I want to convert each timestamp to decimal form, rounded to the nearest 0.5, and return the string. Output should be:

['8,5', '8,0', '0,0', '8,0', '8,0', '8,0', '7,5']

I have some ideas on how to do this but they are all messy on my head and I'm sure there's a function that I don't know that will help, numbers should be rounded between 0 and 5 decimals, so 7:46 would be 8.0, 7:35 would be 7,5 and so on...

Does this answer your question? [Converting string into datetime](https://stackoverflow.com/questions/466345/converting-string-into-datetime) — mkrieger1, Mar 04 '20 at 21:25

maurera · Answer 1 · 2020-03-04T23:01:21.687

0

There are a few steps to this:

Convert your string time to a datetime object
Extract hours as a decimal
Round this to the nearest 0.5
Convert the number to string and replace decimal points with commas

from datetime import datetime
string_times = ['08:29', '08:03', '00:00', '08:09', '08:13', '07:54', '07:30']
numeric_times = []
for s in string_times:
    string_time = datetime.strptime(s, '%H:%M').time()
    numeric_time = string_time.hour+string_time.minute/60
    numeric_time_rounded = round(numeric_time*2)/2
    numeric_times.append(round(numeric_time_rounded,1))
output = [str(x).replace('.',',') for x in numeric_times]
print(output)

Output:

['8,5', '8,0', '0,0', '8,0', '8,0', '8,0', '7,5']

edited Mar 04 '20 at 23:01

answered Mar 04 '20 at 21:22

maurera

1,519
1
15
28

I believe OP would like the output to be rounded to the nearest half hour. i.e. either .5 or .0 – Benjamin Hoving Mar 04 '20 at 21:23
Ah, will update. Question wording is ambiguous because he says "numbers should be rounded between 0 and 5 decimals" – maurera Mar 04 '20 at 21:25
Yeah. It threw me for a second as well. – Benjamin Hoving Mar 04 '20 at 21:26
Yes, the output should be the nearest half hour, that's the correct wording, thanks! I tried this code but I got this exception: AttributeError: module 'datetime' has no attribute 'strptime' What version of python is this for? – user3577419 Mar 04 '20 at 22:09
from datetime import datetime - I've added this to the answer – maurera Mar 04 '20 at 22:11

score 0 · Answer 2 · 2020-03-04T21:33:05.757

There isn't a build-in function. If you wanted to make a command that converts the time into a float, you fist must split the hours and minutes with string.split(":"). Then you can simply do hours+(minutes/60)

Here's the code:

time=['08:29', '08:03', '00:00', '08:09', '08:13', '07:54', '07:30']

def convert(clock_time):
    times = clock_time.split(":")
    hour=int(times[0])
    minutes=int(times[1])

    minutes=(minutes/60)

    if 0.25<minutes<0.75:
        minutes=0.5
    elif 0.75<minutes<1:
        minutes=1
    else:
        minutes=0
    newtime = hour+minutes

    return newtime
for i in range(len(time)):
    print(convert(time[i]))

This code worked like a charm and did exactly what I wanted ! Thank you! — user3577419, Mar 04 '20 at 22:14

Benjamin Hoving · Answer 3 · 2020-03-04T21:28:32.607

-1

This function should work.

def conv(s):
    h, m = s.split(':', maxsplit=2)
    h = int(h)
    m = round(int(m) / 60 * 2) / 2
    if m >= 1:
        h += m // 1
        m %= 1

    return h + m

print(conv('07:44'))
print(conv('07:45'))
print(conv('07:46'))

output:

7.5
8.0
8.0

edited Mar 04 '20 at 21:28

answered Mar 04 '20 at 21:22

Benjamin Hoving

84
1
5

score -1 · Answer 4 · answered Mar 04 '20 at 23:17

Doesn't look great because I created this on my phone, but it should work

times = ['07:46', '07:35', '08:29', '08:03', '00:00', '08:09', '08:13'] 
new_times = [] 

for time in times:
    hours, minutes = time.split(":")
    minutes = round((int(minutes) / 60) * 2) / 2
    time = int(hours) + minutes
    new_times.append(str(time))

How do I turn a strng which represents time to a number in Python? Any built-in function?

4 Answers4