Forum Discussion
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...
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
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