I'm looking for the DAX equivalent to calculate Elapsed time, incorporating both networkdays & Hours of operation. I understand the "networkdays" works around by utilizing calculate and DatesBetween on the Weekend, Holiday dates, but am struggling with a good way to account for the hours of operation.
ElapsedDays = (NETWORKDAYS(A19,B19,Holidays)-1)*($D$2-$C$2)+MOD(B19,1)-MOD(A19,1)
ElapsedHours = ((NETWORKDAYS(A2,B2,Holidays)-1)*($D$2-$C$2)+MOD(B2,1)-MOD(A2,1))*24
[TABLE="width: 500"]
<TBODY>[TR]
[TD]SDT[/TD]
[TD]EDT[/TD]
[TD]WST[/TD]
[TD]WET[/TD]
[TD]ElapsedDays[/TD]
[TD]ElapsedHours[/TD]
[/TR]
[TR]
[TD][TABLE="width: 108"]
<TBODY>[TR]
[TD="align: right"]12/30/2011 10:38:58 AM</SPAN>[/TD]
[/TR]
</TBODY><COLGROUP><COL></COLGROUP>[/TABLE]
[/TD]
[TD]1/5/2012 3:53:57 PM[/TD]
[TD]8:00[/TD]
[TD]17:00[/TD]
[TD]1.34[/TD]
[TD]32.25[/TD]
[/TR]
[TR]
[TD][TABLE="width: 108"]
<TBODY>[TR]
[TD="align: right"]1/18/2011 4:03:44 PM</SPAN>[/TD]
[/TR]
</TBODY><COLGROUP><COL></COLGROUP>[/TABLE]
[/TD]
[TD]1/26/2011 2:29:46 PM[/TD]
[TD]8:00[/TD]
[TD]17:00[/TD]
[TD]2.18[/TD]
[TD]52.43[/TD]
[/TR]
[TR]
[TD]1/18/2011 11:07:00 AM[/TD]
[TD]1/18/2011 11:57:44 AM[/TD]
[TD]8:00[/TD]
[TD]17:00[/TD]
[TD]0.04[/TD]
[TD]0.85[/TD]
[/TR]
</TBODY>[/TABLE]
</SPAN>[TABLE="width: 904"]
<TBODY>[TR]
[TD]
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="colspan: 2"][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="colspan: 2"][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</TBODY><COLGROUP><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL></COLGROUP>[/TABLE]
</SPAN>
ElapsedDays = (NETWORKDAYS(A19,B19,Holidays)-1)*($D$2-$C$2)+MOD(B19,1)-MOD(A19,1)
ElapsedHours = ((NETWORKDAYS(A2,B2,Holidays)-1)*($D$2-$C$2)+MOD(B2,1)-MOD(A2,1))*24
[TABLE="width: 500"]
<TBODY>[TR]
[TD]SDT[/TD]
[TD]EDT[/TD]
[TD]WST[/TD]
[TD]WET[/TD]
[TD]ElapsedDays[/TD]
[TD]ElapsedHours[/TD]
[/TR]
[TR]
[TD][TABLE="width: 108"]
<TBODY>[TR]
[TD="align: right"]12/30/2011 10:38:58 AM</SPAN>[/TD]
[/TR]
</TBODY><COLGROUP><COL></COLGROUP>[/TABLE]
[/TD]
[TD]1/5/2012 3:53:57 PM[/TD]
[TD]8:00[/TD]
[TD]17:00[/TD]
[TD]1.34[/TD]
[TD]32.25[/TD]
[/TR]
[TR]
[TD][TABLE="width: 108"]
<TBODY>[TR]
[TD="align: right"]1/18/2011 4:03:44 PM</SPAN>[/TD]
[/TR]
</TBODY><COLGROUP><COL></COLGROUP>[/TABLE]
[/TD]
[TD]1/26/2011 2:29:46 PM[/TD]
[TD]8:00[/TD]
[TD]17:00[/TD]
[TD]2.18[/TD]
[TD]52.43[/TD]
[/TR]
[TR]
[TD]1/18/2011 11:07:00 AM[/TD]
[TD]1/18/2011 11:57:44 AM[/TD]
[TD]8:00[/TD]
[TD]17:00[/TD]
[TD]0.04[/TD]
[TD]0.85[/TD]
[/TR]
</TBODY>[/TABLE]
</SPAN>[TABLE="width: 904"]
<TBODY>[TR]
[TD]
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="colspan: 2"][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="colspan: 2"][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</TBODY><COLGROUP><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL></COLGROUP>[/TABLE]
</SPAN>