Datetime difference between two columns without counting the full 24 hours

Question

here are two really useful questions for datetime comparison in python:

Calculate Pandas DataFrame Time Difference Between Two Columns in Hours and Minutes

Determine the difference between two DateTimes, only counting opening hours

I have a dataframe in python with two columns:

A                      B
10:00:00 01.01.2019    12:00:00 02.01.2019

And I have opening hours (which are relevant hours), which only should count for the calculation, so not the full 24 hours and maybe not every day. So my business would be open from: 10:00:00 - 18:00:00 every day, how can i adjust:

df_time['td'] = df_time['B']-df_time['A']

That the outcome would be 10 hours in this case? And it is open from monday to friday.

hmm, I answer something similiar and not so easy if want vectorized way. so is possible say need Monday to Friday at 10:00:00 - 18:00:00? Or 7 days in week? — jezrael, Nov 23 '19 at 19:07
lets say monday to friday 10:00 - 18:00, but ofr sure sometimes the monday can be also closed — PV8, Nov 25 '19 at 06:44

score 1 · Answer 1 · answered Nov 22 '19 at 15:09

1

Not a full answer, but I would do:

Count the time in the first day 18:00:00 - df['A'].dt.time
Count the time in the last day df['B'] - 10:00:00
Count the day in between and multiply by 8.

answered Nov 22 '19 at 15:09

Quang Hoang

146,074
10
56
74

Datetime difference between two columns without counting the full 24 hours

1 Answers1