Forum Discussion
COLLEENH
Oct 03, 2019Copper Contributor
formula
I am trying to setup a formula that adds hours worked from sunday to Saturday, but I need Monday to Friday anything under 8 to add into the regular time column and anything over 8 to add with the sunday and Saturday hrs and add to the overtime hours column.
any help would be greatly appreciated.
Thank you
Colleen
p.s copy of excel template attached
2 Replies
- Detlef_LewinSilver Contributor
- COLLEENHCopper Contributor
Thank you for your reply - I think I see what your getting at. I will try and change the structure.
Colleen