Forum Discussion
Sam_French
Mar 01, 2023Copper Contributor
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...
- Mar 01, 2023
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)
Sam_French
Mar 01, 2023Copper Contributor
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.
SergeiBaklan
Mar 01, 2023Diamond Contributor
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)
- Sam_FrenchMar 01, 2023Copper ContributorThat did it! Thank you so much for your help!! 🙂
- SergeiBaklanMar 09, 2023Diamond Contributor
Sam_French , you are welcome