Forum Discussion

KellerB's avatar
KellerB
Frequent Visitor
4 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
    4 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
4 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
    4 years ago

    I just realized my date column contains the day and time so the table creates a new row for everytime. how do i create a new column for just the date? I would like to avoid changing my existing date column as i have measures using it.

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

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

      • KellerB's avatar
        KellerB
        Frequent Visitor
        4 years ago

        Like this? Its giving me an error