Forum Discussion
Help Calculating Business Working hours
Hello Team, Even there is another post with this request I already tried but the answer didnt help me out, I am trying to calculate the working hours between 2 dates using the next formula, the i...
Hello Thanks for the support,
I want to create calculated columns
using this formula "NetwdHours = (CALCULATE(SUM(Calendario[Working Days]),DATESBETWEEN(Calendario[Date],FP[real_Submitted],FP[Real_Closed]))-2)*9" for the first line between the 23/03/2018 and the 02/04/2018 we have 5 working days, if I subtract 2 days I only have 3 working days. Every day has 9 hours, so if I multoply the result should be 3 days * 9 hours = 27 hours (HH:MM)
| Real_Submitted | Real_Closed | Expected result |
| 23/03/2018 16:53 | 02/04/2018 00:06 | 3 working days * 9 hours = 27 hours (HH:MM) |
Thanks