formula

%3CLINGO-SUB%20id%3D%22lingo-sub-891461%22%20slang%3D%22en-US%22%3Eformula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-891461%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20trying%20to%20setup%20a%20formula%20that%20adds%20hours%20worked%20from%20sunday%20to%20Saturday%2C%20but%20I%20need%20Monday%20to%20Friday%20anything%20under%208%20to%20add%20into%20the%20regular%20time%20column%20and%20anything%20over%208%20to%20add%20with%20the%20sunday%20and%20Saturday%20hrs%20and%20add%20to%20the%20overtime%20hours%20column.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eany%20help%20would%20be%20greatly%20appreciated.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%3C%2FP%3E%3CP%3EColleen%26nbsp%3B%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ep.s%20copy%20of%20excel%20template%20attached%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-891461%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-891856%22%20slang%3D%22en-US%22%3ERe%3A%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-891856%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F419448%22%20target%3D%22_blank%22%3E%40COLLEENH%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20you%20change%20the%20structure%20of%20your%20data%20it%20will%20be%20simple.%3C%2FP%3E%3CP%3ESee%20attached%20file.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-891900%22%20slang%3D%22en-US%22%3ERe%3A%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-891900%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1639%22%20target%3D%22_blank%22%3E%40Detlef%20Lewin%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20for%20your%20reply%20-%20I%20think%20I%20see%20what%20your%20getting%20at.%26nbsp%3B%20I%20will%20try%20and%20change%20the%20structure.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EColleen%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New 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
Highlighted

@COLLEENH 

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

See attached file.

 

Highlighted

@Detlef Lewin

 

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

 

Colleen