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

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.

 

  • JoeBarry's avatar
    JoeBarry
    Solution Sage
    2 years ago

    sorry, i copied the code from the formula bar, please remove the each part. Also please filter out the blank values in the rate column beforehand