1 Reply Latest reply on Feb 2, 2017 3:12 PM by Patrick A Van Der Hyde

Calculate only Business days(in minutes) by Excluding weekends and Holidays

Jilani Shaik Feb 1, 2017 9:56 AM

How to calculate only Business days by excluding weekends and holidays

i want to calculate the duration in minutes after excluding the weekends and holidays

in the above img (start date time stamp - end Date time stamp) excluding the weekends and holidays in both the fields

1. Re: Calculate only Business days(in minutes) by Excluding weekends and Holidays

Patrick A Van Der Hyde Feb 2, 2017 3:12 PM (in response to Jilani Shaik)

Jilani Shaik,

You will probably get a more useful answer if you have a bit of sample data to share in a .twbx file. Otherwise, I suggest checking out this exchange from a previous thread - Holiday calculation excluding Holidays and Weekends by Region

I hope that helps.

Patrick
Like Show 0 Likes(0)

Actions

Tableau Community Forums