Forum Discussion
Employee planned hours gant calendar
Hello, We currently have a calendar list view that shows each consultant planned hours/day, there are 3 types of hours, ''free'' ''internal'' & ''work''. A day can consist of all 3 types of hours or 1-2.
The table we currently use looks like this (problem is that it can only show 1 of the 3 category hours planned)
So far I've combined the tables in a query (3 tables, 1 for each hour) & create a pivot table.
The problem with this is that it does not really look like a calendar like the first one, and it's also missing some days like weekends, etc since the original list only has the days that are actually planned.
If anyone has any tips on the grant chart layout or have any similar templates I would appreciate it!
Hi Virtual123
Does this look like what you're after (dummy data added to yours)?
Pivot Table from Excel Data Model => Excel >/= 2013 on Windows required
EDIT Forgot to mention it's also possible to get short dates (23-01-04, ...23-01-15...) with a hidden helper row (to limit calculations in Conditionnal Formatting rules) on the sheet
- Looks very good! Thank you for the help, is it possible to transpose the hours into 3 rows instead of columns? That way more dates can fit the page
is it possible to transpose the hours into 3 rows instead of columns? That way more dates can fit the page?
Not sure I understand... that would give you what you already have:
