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)
SergeiBaklan
Mar 01, 2023Diamond Contributor
How 42 hours appear in E, do you enter it manually or it's calculated by formula? If the latest by which one?
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.
- SergeiBaklanMar 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