Forum Discussion
Solved
Calculating Hours and Rolling Into OT
I'm trying to add all hours in one column to show sum a sum up to 40 but have anything over 40 roll over into the next column as overtime. Can anybody help?
You can use
=MIN(SUM(range), 40)
and
=MAX(SUM(range)-40, 0)
You can use
=MIN(SUM(range), 40)
and
=MAX(SUM(range)-40, 0)