Home

RE: Get started with Excel, find Featured training and more

%3CLINGO-SUB%20id%3D%22lingo-sub-797586%22%20slang%3D%22en-US%22%3ERE%3A%20Get%20started%20with%20Excel%2C%20find%20Featured%20training%20and%20more%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-797586%22%20slang%3D%22en-US%22%3EThanks%20Pham%20I%20am%20developing%20a%20small%20project%20for%20my%20office%20to%20maintain%20attendance%20record%20with%20some%20rules%20and%20i%20am%20stuck%20in%2014%20hrs%20rule%20and%208hr%20gap.%20if%20anyone%20can%20help%20will%20be%20much%20appropriated.%20ITs%20a%20Sunday%20to%20Monday%20roster.%20Rules%20for%20excel%3A%20A%20Person%20cannot%20work%20more%20than%2014%20hrs%20a%20day%20not%208%20days%20in%20a%20row%208%20hours%20gap%20in%20between%20the%20shifts%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-800537%22%20slang%3D%22en-US%22%3ERE%3A%20RE%3A%20Get%20started%20with%20Excel%2C%20find%20Featured%20training%20and%20more%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-800537%22%20slang%3D%22en-US%22%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F389919%22%20target%3D%22_blank%22%3E%40Excel040%3C%2FA%3Ecan%20you%20provide%20a%20sample%20spreadsheet%20of%20what%20you're%20looking%20for%3F%20Once%20we%20understand%20your%20input%2Foutput%2C%20someone%20like%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3Ecan%20probably%20help%20you%20with%20the%20formulae%3C%2FLINGO-BODY%3E
Highlighted
Excel040
Occasional Visitor
Thanks Pham I am developing a small project for my office to maintain attendance record with some rules and i am stuck in 14 hrs rule and 8hr gap. if anyone can help will be much appropriated. ITs a Sunday to Monday roster. Rules for excel: A Person cannot work more than 14 hrs a day not 8 days in a row 8 hours gap in between the shifts
1 Reply
@Excel040 can you provide a sample spreadsheet of what you're looking for? Once we understand your input/output, someone like @Sergei Baklan can probably help you with the formulae
Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies