Forum

Notifications
Clear all

Work and Absence Schedule half days calculate

2 Posts
2 Users
0 Reactions
255 Views
(@tuki_69)
Posts: 1
New Member
Topic starter
 

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.

 
Posted : 10/12/2022 6:40 am
(@mynda)
Posts: 4761
Member Admin
 

Hi Fahruk,

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.

Mynda

 
Posted : 10/12/2022 8:40 pm
Share: