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

[Excel040]

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

[#2]

@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