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)
2 Replies
I am always interested -- as a person who once directed the HR/payr0ll database of a major corporation--in how people like you approach organizing your workbooks for what is (in this case) obviously work and pay related information.
Would you be willing to share a copy of the workbook, changing any names to fictitious ones, as well as any other identifiable or confidential information? I ask not just out of curiosity, but because my experience might serve to give you suggestions on more efficient ways to achieve things.
You can use
=MIN(SUM(range), 40)
and
=MAX(SUM(range)-40, 0)
