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, 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

  • KellerB's avatar
    KellerB
    Frequent Visitor
    4 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
      4 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. 

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

    Sorry, my mistake. Are you able to add columns in power query. If so create a custom column with Date.From([DateTimeCol]) call it something like date only and the replace the datetime with the date only column on the summarize table.