I'm trying to calculate the sum of hours in a row in a shift rosta
The staff put their hours of TOIL or FLEX in the rota eg. T1 T2 T4 T8 etc etc where staff have accrued hours toil, and F1 F2 F4 F8 etc where staff have accrued hours flex time.
At the end of the row Id like to see the total of hours toil and in the next column the total of hours flex.
Seems like it should be easier than im finding it
The staff put their hours of TOIL or FLEX in the rota eg. T1 T2 T4 T8 etc etc where staff have accrued hours toil, and F1 F2 F4 F8 etc where staff have accrued hours flex time.
At the end of the row Id like to see the total of hours toil and in the next column the total of hours flex.
Seems like it should be easier than im finding it