Check time within specific time ranges

[basvdm]

Hello,

I got the following case:

time slots:

From. To. Multiplier
9:00 19:59 1
20:00 21:59 2
22:00 23:59 3
0:00 6:59 4
7:00 8:59 2

I would like to compute the sum of the minutes of the time between starttime and endtime in each time slot multiplied by their multiplier.

So for example:

starttime = 08:11
endtime = 14:16

will lead to 48 minutes x 1.5 + 316 minutes x 1 = 388.

Can anyone help me writing a code for this?

[deanhystad]

Your example is wrong:

So for example:

starttime = 08:11
endtime = 14:16

will lead to 48 minutes x 1.5 + 316 minutes x 1 = 388.

The time overlaps are correct, but the multiplier for 7:00 8:59 is 2, not 1.5.

It will be easier if you convert all times to minutes. datetime makes this easy.

The intersection of time windows a and b is:
start = max(a_start, b_start)
end = max(start, min(a_end, b_end))

8:11 = 491 minutes
14:16 = 856 minutes
9:00 = 540 minutes
19:59 = 1199 minutes
start = max(491, 540) = 540
end = max(540, min(856, 1199)) = 856
overlap = 856 - 540 = 316 minutes

[Keville_35]

Okay can you try this one?

from datetime import datetime, timedelta def compute_weighted_minutes(starttime, endtime, time_slots): # Convert input times to datetime objects starttime = datetime.strptime(starttime, "%H:%M") endtime = datetime.strptime(endtime, "%H:%M") # Handle case where endtime is past midnight if endtime < starttime: endtime += timedelta(days=1) total_weighted_minutes = 0 for slot in time_slots: slot_start = datetime.strptime(slot["From"], "%H:%M") slot_end = datetime.strptime(slot["To"], "%H:%M") # Adjust slots for crossing midnight if slot_end < slot_start: slot_end += timedelta(days=1) # Determine overlap between time interval and current slot overlap_start = max(starttime, slot_start) overlap_end = min(endtime, slot_end) if overlap_start < overlap_end: overlap_minutes = (overlap_end - overlap_start).seconds // 60 total_weighted_minutes += overlap_minutes * slot["Multiplier"] return total_weighted_minutes # Define time slots with multipliers time_slots = [ {"From": "09:00", "To": "19:59", "Multiplier": 1}, {"From": "20:00", "To": "21:59", "Multiplier": 2}, {"From": "22:00", "To": "23:59", "Multiplier": 3}, {"From": "00:00", "To": "06:59", "Multiplier": 4}, {"From": "07:00", "To": "08:59", "Multiplier": 2}, ] # Example usage starttime = "08:11" endtime = "14:16" result = compute_weighted_minutes(starttime, endtime, time_slots) print("Total weighted minutes:", result)

[Gribouillis]

Okay here it's

@Keville_35 This is a Python forum but your code is not Python code. What is the point of posting this?