Skip to Content
0
Former Member
Sep 27, 2017 at 08:10 PM

Exclude weekend hours between two days

123 Views

Hi community,

I've got a difficult task. I need to get minutes between two date field in a report.

And this difference need to exclude weekend hours, moreover minutes need to be calculated by working hours.

Here is an example:

DATE1 20/09/2017 14:56 DATE2 27/09/2017 23:02

Need difference like DATE2-DATE1 just with working hours (9:00am till 6:00pm) 8 hours per day

How it could be resolve ?

Any help will be appreciate!