1 of 1 people found this helpful
As per my understanding , first you need to calculate the weekdays i,e you need to exclude the weekends . And once you get the no of weekdays then you can convert those days into working hours.I am not sure weather it will solve your problem fully or not but at least it will give you a start .
Calculate the Number of Business Days Between Two Dates
Follow the steps below to calculate the number of business days between two dates using a calculated field. Download and open the Calculate Business Days Two Dates workbook to follow the steps below.
In Tableau Desktop, select Analysis > Create Calculated Field.
In the Calculated Field dialog box that opens, enter a name for the field.
In the formula field, type the following, and then click OK:
DATEDIFF('week',[<Start Date>],[<End Date>])*5
<End Date>are the names of date fields in the worksheet.