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.

KellerB's avatar
KellerB
Frequent Visitor
3 years ago

Like this? Its giving me an error

KellerB's avatar
KellerB
Frequent Visitor
3 years ago

Ok I used .[date] on the end and that seemed to work. However I realized that I am have separate shifts....

Day shift = 5am-6pm

Night Shift = 10pm-6am

I already have in my table what shift each row belongs to so I just need to somehow get it in the summarized table calculation. 

THanks for all your help!

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

    Oddly enough .[Date] didn't work for me when I tried it and I thought it wasn't accepted in a summarize.  😊 if I've helped you, please accept my solution, if not let me know if there is anything else I can do.