Forum Discussion
Calculate working hours between two dates
I'm trying to calculate the number of working hours/minutes between two dates (ie. excluding non-working hours and weekends). This is the basic format - and I'm trying to find out how long it t...
Hi,
Looking at calculate minutes between a ticket was created and closed.
The measure needs to consider the following:
- Should ignore public holidays (Have a table called public holidays in which the date column has the days I have as public holidays)
- Should consider Mon to Friday
- Business Hours 7 am to 5 pm
- If completed is greater than created then should take it as 0
Step created at AEDT Step Completed at AEDT
15/6/21 11:32:24 am 16/6/21 2:22:46 pm
Any help will be appreciated