How to calculate Working Hours between 2 dates

How to calculate working hours between 2 dates, excluding weekends and bankholidays.
I need exact working hours and not days.

Hi @Daniel15
are you dates on a daily or hour bases?

You could use

to check if the start and end date is a work day. Calculate the remaining working hours.

Count the workdays between

And multiple with you working hours per day.
Bring it all together.


The dates are on hourly basis… I need exact number of working hours/mins between 2 dates…





Ok, but did you check the approach?