Home

Excell spreadsheet

%3CLINGO-SUB%20id%3D%22lingo-sub-751437%22%20slang%3D%22en-US%22%3EExcell%20spreadsheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-751437%22%20slang%3D%22en-US%22%3EIf%20I%20work%2011hrs%20how%20do%20I%20move%20hrs%20above%208%20to%20the%20next%20cell%20and%20any%20hrs%20over%202%20to%20a%20third%20cell%3F%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-751437%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-751530%22%20slang%3D%22en-US%22%3ERe%3A%20Excell%20spreadsheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-751530%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F375163%22%20target%3D%22_blank%22%3E%40gbat228836%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eassuming%20A2%20has%20total%20hours%20(11)%2C%20you%20can%20have%20following%20formulae%20for%20next%203%20cells%26nbsp%3B%3C%2FP%3E%3CP%3ECell%20B2%20(8%20hours%20or%20less)%26nbsp%3B%20%26nbsp%3B%20%3DIF(A2%26gt%3B8%2C8%2CA2)%3C%2FP%3E%3CP%3ECell%20C2%26nbsp%3B%20(2%20hours%20above%208)%26nbsp%3B%20%26nbsp%3B%3DIF(A2%26gt%3B%3D10%2C2%2CMAX(0%2CA2-8))%3C%2FP%3E%3CP%3ECell%20D3%20(%20hours%20above%2010)%26nbsp%3B%20%26nbsp%3B%26nbsp%3B%3DMAX(0%2CA2-B2-C2)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
gbat228836
New Contributor
If I work 11hrs how do I move hrs above 8 to the next cell and any hrs over 2 to a third cell?
1 Reply

@gbat228836 

 

assuming A2 has total hours (11), you can have following formulae for next 3 cells 

Cell B2 (8 hours or less)    =IF(A2>8,8,A2)

Cell C2  (2 hours above 8)   =IF(A2>=10,2,MAX(0,A2-8))

Cell D3 ( hours above 10)    =MAX(0,A2-B2-C2)

 

 

Related Conversations
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
2 Replies
*Updated 9/3* Syncing in Microsoft Edge Preview Channels
Elliot Kirk in Articles on
202 Replies
Early preview of Microsoft Edge group policies
Sean Lyndersay in Discussions on
65 Replies