Oct 03 2019 08:44 AM
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
Oct 03 2019 10:31 AM
Oct 03 2019 10:46 AM
Thank you for your reply - I think I see what your getting at. I will try and change the structure.
Colleen