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)
You could use:
=LET(total,SUM(hours),IF(total<=40,total,HSTACK(40,MOD(total,40))))This will do regular and any OT, all in one move.
Thank you, but I can't seem to get this to work with what I want it to do