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
COLLEENH
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

@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

Related Conversations
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
Edge insider Dev bypasses IE mode website list
HotCakeX in Enterprise on
4 Replies