Forum Discussion
Solved
Remainder of 40 in one column to another Column
Hello! I hope someone can help. I'm working with time cards and making a spreadsheet. I have an employees total hours in Column E and would like any hours over 40 to go into Column F (for overti...
If no formula in E and value appears here by some magic way, I'd suggest to add two columns, with regular hours and overwork
Regular: =IF(E2<=40,E2,40) Overwork: =MAX(0, E2-40)
Its placed on there when I run a hourly report from our time clocks, but it doesn't separate regular hours and overtime hours. It doesn't appear to have any formulas on it.
If no formula in E and value appears here by some magic way, I'd suggest to add two columns, with regular hours and overwork
Regular:
=IF(E2<=40,E2,40)
Overwork:
=MAX(0, E2-40)- That did it! Thank you so much for your help!! 🙂
Sam_French , you are welcome