Math
1 Topic
Automatic Addition, Numerical Limit and Overflow
I am creating an overtime report sheet for a crew ranging from 20 to 75 people. Rather than type up all of the hours for each individual, highlighting everyone's times and then using the sum feature to get their totals into column L, I would much prefer having their times automatically add up into column L as I type them. Is this possible? Additionally, In column M, I input regular hours, so even if someone works 55, column M will say 40 and in Column N would go the 15 overtime hours. Can I make it so that if a value greater than 40 is put into Column M the remaining value could automatically overflow onto the next column? P.S. In Column O is the premium time which is just half of the overtime, but I managed to automate that to divide values in Column N by 2. This is all I've figured as I don't have much Excel experience and am unsure how else to find these answers.Solved4.3KViews0likes7Comments