formula

Copper Contributor

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

@COLLEENH 

If you change the structure of your data it will be simple.

See attached file.

 

@Detlef Lewin

 

Thank you for your reply - I think I see what your getting at.  I will try and change the structure.

 

Colleen