December 9, 2022
I’m using this employee absence schedule excel template and I’m satisfied with this but only thing which I can’t solve is how to get the formula to add two different actions in one cell for same day e.g. 0.5 day production 0.5 day vacation.
On attachment is my excel template.
Thank you in advance for your help.
July 16, 2010
Welcome to our forum! Thanks for sharing your file and example of the problem. Unfortunately, Excel wasn't designed to work with multiple pieces of information in a single cell, which is why you're struggling with a formula that will do what you want. Because of the inconsistency of the data, you won't find a solution to this problem.
Instead, you should be entering your data in a tabular layout as it happens. That also means one table for all records, not separate ones for each month. From there you can use PivotTables to summarise the data into the reports you need. If you keep your data spread over multiple sheets, you will also struggle to summarise the monthly data, but you won't have this problem with PivotTables.
See example file attached.
I hope that points you in the right direction. See the links above for further information and tutorials.