Forum Discussion
Calculating filled working hours
Hi,
You may refer to my solution in this file. I have assumed working days as Monday - Friday and 8 working hours per day. Hours will be summed up from the first date in the Calendar table till the Month/Year chosen in the slicer.
Hope this helps.
Super UserHi,
You may refer to my solution in this file. I have assumed working days as Monday - Friday and 8 working hours per day. Hours will be summed up from the first date in the Calendar table till the Month/Year chosen in the slicer.
Hope this helps.
Thank you for your quick reply! I have learned lots from that code
However I get an annoying error as you see below. The total add up correctly, but if I drill down on employee i get the total of the table for all employees for "hours worked" (and thus effecting hours worked until selection period). Do you know why this is happening? Potential hours are adding upp correctly per employee
- Ashish_Mathur
Thank you! Works great, I probably mixed something up in my own file
- Ashish_Mathur
You are welcome.