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!