Forum Discussion

Justas4478's avatar
Justas4478
Post Prodigy
2 years ago
Solved

Combining multiple columns to add time together

Hello, I have multiple columns that have work time per day in them. These columns represent different pay rate that is payed for the work time. There is 20 rate columns but data really show mainly in...
Need Help
  • JoeBarry's avatar
    JoeBarry
    2 years ago

    ok, create a new column. and add this code 

    each Duration.FromText([Rate]) / #duration(0, 0, 1, 0))

     

    This converts the hours into minutes. Delete the Rate column. Highlight the date column, go to the Ribbion > Home > Group by Operation is Sum and choose the new minutes column to do the sum.

     

    This will group all the minutes in to one day. You can then divide by 60 to get the hours worked.

     

    Thanks

    Joe

Justas4478's avatar
Justas4478
Post Prodigy
2 years ago

JoeBarry It looks better, but how do I combine different rates of same day in to one?

 

JoeBarry's avatar
JoeBarry
Solution Sage
2 years ago

Should the result be 9:00 here?

  • Justas4478's avatar
    Justas4478
    Post Prodigy
    2 years ago

    JoeBarry If we dont look at it as different rates then yes result would be 09:00 

    Since 01:00 is overtime and still needs to be included in total time for the day.

    • JoeBarry's avatar
      JoeBarry
      Solution Sage
      2 years ago

      ok, create a new column. and add this code 

      each Duration.FromText([Rate]) / #duration(0, 0, 1, 0))

       

      This converts the hours into minutes. Delete the Rate column. Highlight the date column, go to the Ribbion > Home > Group by Operation is Sum and choose the new minutes column to do the sum.

       

      This will group all the minutes in to one day. You can then divide by 60 to get the hours worked.

       

      Thanks

      Joe

      • Justas4478's avatar
        Justas4478
        Post Prodigy
        2 years ago

        JoeBarry I am getting this error when I try to use the code.