Rounding up to nearest 30 minutes in python

Question

I have the following code below.

I would like to roundup TIME to the nearest 30 minutes in the hour. For example: 12:00PM or 12:30PM and so on.

EASTERN_NOW = timezone.localtime(timezone.now() + timedelta(minutes=30))

TIME = datetime.time(EASTERN_NOW.time().hour, EASTERN_NOW.time().minute).strftime(
    VALID_TIME_FORMATS[2])

Thanks in advance

score 37 · Answer 1 · edited May 23 '17 at 12:26

37

To round up to the nearest 30 minutes:

#!/usr/bin/env python3
from datetime import datetime, timedelta

def ceil_dt(dt, delta):
    return dt + (datetime.min - dt) % delta

now = datetime.now()
print(now)    
print(ceil_dt(now, timedelta(minutes=30)))

The formula is suggested by @Mark Dickinson (for a different question).

Output

2015-09-22 19:08:34.839915
2015-09-22 19:30:00

Note: if the input is timezone-aware datetime object such as EASTERN_NOW in your case then you should call timezone.make_aware(rounded_dt.replace(tzinfo=None)) if you want to preserve the rounded local time and to attach the correct tzinfo, otherwise you may get wrong timezone info if the rounding crosses DST boundaries. Or to avoid failing for ambiguous local time, call .localize() manually:

localize = getattr(rounded_dt.tzinfo, 'localize', None)
if localize:
   rounded_dt = localize(rounded_dt.replace(tzinfo=None),
                         is_dst=bool(rounded_dt.dst()))

edited May 23 '17 at 12:26

Community

1
1

answered Sep 22 '15 at 19:08

jfs

374,366
172
933
1,594

I'm getting `TypeError: unsupported operand type(s) for %: 'datetime.timedelta' and 'datetime.timedelta'` – dan-klasson Jul 11 '17 at 19:25
3

@dan-klasson notice: the python3 shebang in the script – jfs Jul 11 '17 at 19:26
1

Any Python 2.x equivalent for this? – Rainymood Apr 18 '18 at 08:32
@Rainymood: click the link in the answer and look at other answers (the idea is to convert the timedelta to seconds: 1800 in this case). See whether [replacing 900 with 1800 works](https://stackoverflow.com/a/13071613/4279) – jfs Apr 18 '18 at 09:10

score 10 · Answer 2 · answered May 10 '18 at 08:06

to round forward you can use :

#!/usr/bin/env python3
from datetime import datetime, timedelta

def ceil_dt(dt, delta):
    return dt + (datetime.min - dt) % delta

now = datetime.now()
print(now)    
print(ceil_dt(now, timedelta(minutes=30)))

To round back to the nearest 30th minute

def rounded_to_the_last_30th_minute_epoch():
    now = datetime.now()
    rounded = now - (now - datetime.min) % timedelta(minutes=30)
    return rounded

multivac · Answer 3 · 2015-09-22T18:00:49.340

3

You can divide your minutes by 30, round that and multiply by 30 again to get either 0, 30 or 60 minutes:

date = datetime.datetime(2015, 9, 22, 12, 35)
approx = round(date.minute/30.0) * 30

date = date.replace(minute=0)
date += datetime.timedelta(seconds=approx * 60)
time = date.time()
print(time.strftime('%H:%M'))
# prints '13:30'

I'm using a datetime object because timedelta doesn't work with time objects. In the end you can obtain the time using date.time().

edited Sep 22 '15 at 18:00

answered Sep 22 '15 at 17:54

multivac

146
5

great..do you have any idea on how to round down to the nearest 10 or 20 minutes.. – Azam Jan 01 '21 at 06:40
1

@Azam The same way. You divide your minutes by 10, drop the remainder then multiply it by 10. So 36 minutes will be first 3.6, then you drop the fractional part (or use integer divide which only leaves the whole numbers) then you multiply by 10 -> 30. Same for 20 minutes. 36 / 20 -> 1.8, drop the fractional part that leaves 1, multiply by 20 -> 20 minutes – karatedog Jul 16 '21 at 19:54

LetzerWille · Answer 4 · 2015-09-22T20:42:58.437

you can just take datetime input apart and ajust time

 def ajustTime():

from datetime import datetime

mytime= datetime.now().strftime("%Y-%m-%d %H-%M")

m = mytime.split()

hours, mints = m[1].split('-')

if 15 <= int(mints) <= 45:
    mints = ':30'
elif int(mints) < 15:
    mints = ':00'
elif int(mints) > 45:
    mints = ':00'
    h = int(hours) + 1
    hours = str(h)

print(m[0] + " " + hours + mints)

ajustTime()

output

2015-09-22 15:42:03.587633

2015-09-22 15:30

2015-09-22 15:46:01.956860

2015-09-22 16:00

score 2 · Answer 5 · edited Aug 19 '16 at 07:36

2

>>> from dateutil.rrule import rrule, MINUTELY
>>> import datetime
>>> import bisect
>>> times = list(rrule(MINUTELY,interval=30,dtstart=datetime.date.today(),count=
48))
>>> print times[bisect.bisect(times,datetime.datetime.now())]
2015-09-22 11:00:00
>>>

Note that this solution uses the 3rd party dateutil library that can be installed with pip install dateutil... Of course, you could solve it without it... but it's easier with it.

edited Aug 19 '16 at 07:36

Community

1
1

answered Sep 22 '15 at 17:41

Joran Beasley

103,130
11
146
174

Thanks Joran will try it out and let you know. – user875139 Sep 22 '15 at 17:42
Joran it worked but what I am looking for is that, if its 1:15 or 1:17 that the time should show as 1:30 and not 30 minutes ahead of 1:15 or 1:17. – user875139 Sep 22 '15 at 18:24
it should indeed round to the nearest :30 or :00 (ahead of where it is)... did you try this? – Joran Beasley Sep 22 '15 at 19:19
nice it does work. I'm just trying to get it in the format of "04:30 PM" in my timezone now. – user875139 Sep 22 '15 at 19:38
what do you mean? nevermind i understand after reading the other answer . :P – Joran Beasley Sep 22 '15 at 21:08

myles · Answer 6 · 2019-05-31T02:59:20.717

To round down:

extract the minute from the time that you want to round
using floor division, find the whole number intervals there are in the current hour (from the floor division of the current minute and the time interval, i.e. the intervals that you want to round down to).
multiply the time interval by that whole number, which gives you the rounded down minutes
use .replace() to change the minutes to those rounded down minutes (and seconds and milliseconds to zero).

Or, in words, using the number of whole intervals (x) there are in the current minutes, replace the minutes by that number of intervals (x * interval):

#!/usr/bin/env python3
def floor_dt(dt, interval):
    replace = (dt.minute // interval)*interval
    return dt.replace(minute = replace, second=0, microsecond=0)

print(datetime.now())
# datetime.datetime(2019, 5, 30, 22, 25, 31, 115901)
print(floor_dt(datetime.now(),30))
# datetime.datetime(2019, 5, 30, 22, 0)

print(datetime.now())
# datetime.datetime(2019, 5, 30, 22, 26, 29, 469555)
print(floor_dt(datetime.now(),10))
# datetime.datetime(2019, 5, 30, 22, 20)

score 2 · Answer 7 · answered Dec 15 '20 at 21:24

To round down and up you can use these two functions. You don't need to calculate seconds or use math module.

from datetime import timedelta, datetime

def ceil_date(date, **kwargs):
    secs = timedelta(**kwargs).total_seconds()
    return datetime.fromtimestamp(date.timestamp() + secs - date.timestamp() % secs)

def floor_date(date, **kwargs):
    secs = timedelta(**kwargs).total_seconds()
    return datetime.fromtimestamp(date.timestamp() - date.timestamp() % secs)

Usage is similar to timedelta because kwargs is passed

now = datetime.now() #15:12:12

ceil_date(now, minutes=5) #15:15:00
floor_date(now, minutes=5) #15:10:00

David · Answer 8 · 2022-02-03T18:06:44.077

I have written this function that rounds to any unit from fraction of seconds to one day:

from datetime import datetime
from datetime import timedelta

def round_time(dt: datetime, unit=timedelta(seconds=1)):
    seconds = (dt - datetime.min).total_seconds()
    unit_seconds = unit.total_seconds()
    half_over = seconds + unit_seconds / 2
    rounded_seconds = half_over - half_over % unit_seconds
    return datetime.min + timedelta(seconds=rounded_seconds)

Outputs

dt
# datetime.datetime(2022, 2, 3, 17, 44, 56, 659595)

round_time(dt)
# datetime.datetime(2022, 2, 3, 17, 44, 57)

round_time(dt, timedelta(seconds=5))
# datetime.datetime(2022, 2, 3, 17, 44, 55)

round_time(dt, timedelta(seconds=0.25))
# datetime.datetime(2022, 2, 3, 17, 44, 56, 750000)

round_time(dt, timedelta(minutes=1))
# datetime.datetime(2022, 2, 3, 17, 45)

round_time(dt, timedelta(minutes=30))
# datetime.datetime(2022, 2, 3, 17, 30)

round_time(dt, timedelta(hours=1))
# datetime.datetime(2022, 2, 3, 18, 0)

round_time(dt, timedelta(hours=12))
# datetime.datetime(2022, 2, 3, 12, 0)

round_time(dt, timedelta(days=1))
# datetime.datetime(2022, 2, 4, 0, 0)

score 1 · Answer 9 · answered Sep 22 '15 at 17:52

1

this should work too, not sure about time zones though

rounded=time.gmtime(30*60*(round(time.time()/(30*60))))

answered Sep 22 '15 at 17:52

karakfa

64,710
7
38
55

score 1 · Answer 10 · answered Sep 22 '15 at 20:37

1

Thanks for all the input guys. I solved this with my own approach.

min_time = timezone.localtime(timezone.now())
min_time_est = min_time.minute 
if min_time_est > 30:
    add_mins = 60 - min_time_est
else:
    add_mins = 30 - min_time_est

EASTERN_NOW = timezone.localtime(timezone.now() + timedelta(minutes=add_mins))
TIME = datetime.time(EASTERN_NOW.time().hour, EASTERN_NOW.time().minute).strftime(
    VALID_TIME_FORMATS[2])

In case anyone else has a similar problem. The about 'TIME' outputs every 30 mins e.g '1:00PM' or '1:30PM'.

answered Sep 22 '15 at 20:37

user875139

1,479
4
22
41

use `add_mins = -min_time.minute % 30` (your code skips 30 minutes unnecessarily if `.minute==0`). Your code may fail if changes in the utc offset for the current timezone are not aligned with 30 minutes ([my answer calls `localize()` to keep the time while getting the correct tzinfo](http://stackoverflow.com/a/32724959/4279)) – jfs Sep 22 '15 at 21:28
use `eastern_now.strftime(valid_time_format)` (no need to call `eastern_now.time()`, no need to construct `datetime.time()` again). – jfs Sep 22 '15 at 21:32

Matt · Answer 11 · 2017-09-27T01:18:39.617

1

Round up to nearest amount specified in minutes via round_mins without using third-party libraries and just a few lines of code.

import datetime
round_mins = 30
now = datetime.datetime.now()
mins = now.minute - (now.minute % round_mins)
print datetime.datetime(now.year, now.month, now.day, now.hour, mins) + datetime.timedelta(minutes=round_mins)

edited Sep 27 '17 at 01:18

answered Sep 22 '17 at 18:55

Matt

3,263
4
33
43

3

Please provide a bit of explanation. Code-only answers are often not as helpful to people who come here with the same problem in the future. – Engineero Sep 22 '17 at 19:21

MarcusAurelius · Answer 12 · 2022-03-26T15:48:27.920

The function below can round any time string to hours, minutes, seconds by setting parmeter 'unit', default is the smallest format of ts. Parameter 'ts' is the time string you want to round, the fuction accept multiple time formats. With parmeter 'rnd' you can set the number you want to round at, default is 1. With parmeter 'frm' you can set the format of the output string, as default the function takes the format of ts. Just play with the function and you will see how easy it will be. The function even convert time strings between 12 and 24 hours format and vice versa. All this with a minimum on import.

def toNearestTime(ts, unit=None, rnd=1, frm=None):

    ''' round to the Nearest Time
    param ts = auto recognize the most time patterns : not date-time
    param unit = specify unit wich must be rounded 'sec' or 'min' or 'hour', default is the smallest unit of ts :
    param rnd = to which number you will round, the default is 1 :
    param frm = the output (return) format of the time string you want, as default the function take the ts format'''

    from time import strftime, gmtime, strptime
    ustp = ["AM", 'PM']

    if any(e in ts for e in ustp):
        time12_pat = {'%I:%M%p': 'm', '%I:%M %p': 'm', '%I:%M:%S%p': 'se', '%I:%M:%S %p': 'se', '%I%M%p': 'm', '%I%M %p': 'm', '%I%M%S%p': 'se', '%I%M%S %p': 'se'}
        for p, u in time12_pat.items():
            try:
                ts = strftime('%H:%M:%S', strptime(ts, p))
                break
            except:
                continue
        sf = p
        unit = time12_pat[sf] if unit is None else unit
    else:
        time24_pat = {'%H:%M': 'm', '%H:%M:%S': 'se', '%H': 'h', '%H%M': 'm', '%H%M%S': 'se'}
        for p, u in time24_pat.items():
            try:
                ts = strftime('%H:%M:%S', strptime(ts, p))
                break
            except:
                continue
        sf = p
        unit = time24_pat[sf] if unit is None else unit
    if 'se' in unit.lower():
        frm = sf if frm is None else frm
    elif 'm' in unit.lower():
        frm = sf if frm is None else frm
        rnd = rnd * 60
    elif 'h' in unit.lower():
        frm = p if frm is None else frm
        rnd = rnd * 3600
    secs = sum(int(x) * 60 ** i for i, x in enumerate(reversed(ts.split(':'))))
    rtm = int(round(secs / rnd, 0) * rnd)
    nt = strftime(frm, gmtime(rtm))
    return nt

Call function as follow: Round to nearest 5 minutes with ouput format = hh:mm as follow

ts = '02:27:29'
nt = toNearestTime(ts, unit='min', rnd=5, frm='%H:%M')
print(nt)
output: '02:25'

Or round to nearest 30 minutes with ouput 12 hour format hh:mm:ss as follow

ts = '11:14PM'
nt = toNearestTime(ts, rnd=30, frm='%I:%M:%S %p')
print(nt)
output: '11:00:00 PM'

Rounding up to nearest 30 minutes in python

12 Answers12

Output

Outputs

Linked