Forum Discussion

BisonMike's avatar
BisonMike
Regular Visitor
8 years ago
Solved

Calculating filled working hours

Hi community   I have a problem that is bugging me. I'm trying to how much logging hours our employees has entered in the system compared to the total nr of working hours for the month. If we have ...
  • Ashish_Mathur's avatar
    Ashish_Mathur
    8 years ago

    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.

     

Ashish_Mathur's avatar
Ashish_Mathur
Super User
8 years ago

Hi,

 

I do not face any such problem.  Download the revised file from here.

 

BisonMike's avatar
BisonMike
Regular Visitor
8 years ago

Thank you! Works great, I probably mixed something up in my own file

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    8 years ago

    You are welcome.