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