Forum Discussion

KellerB's avatar
KellerB
Frequent Visitor
3 years ago
Solved

Calculating hours worked over x days excluding down time

Hi! I have a problem that I have been trying to solve for days. I need to calculate working hours by manufacturing line over multiple days. the problem is I have to do this by time of first unit prod...
Need Help
  • davehus's avatar
    davehus
    3 years ago

    Hi KellerB ,

     

    I've attached a solution using a summarized table. Let me know if this meets your needs.

     

    Did I help you today? Please accept my solution and hit the Kudos button.

davehus's avatar
davehus
Icon for Memorable Member rankMemorable Member
3 years ago

Hi KellerB, Try wrapping the datetime in Date() in the summarize table. 

KellerB's avatar
KellerB
Frequent Visitor
3 years ago

Are you able to do a virtual call sometime tomorrow or next week? I feel like i am not good at explaining what is not working haha.

  • davehus's avatar
    davehus
    Icon for Memorable Member rankMemorable Member
    3 years ago

    Yes sure. Next week is fine if that suits. Private message me on the community and we'll go from there.