Hello All,
I am having to create a rota system for where I work. This in itself is fine, the important people want a visual view of each team ad their individual shifts. However the also want an overview that they can look at each day with just the start and finish time viewable.
ie: -
Names - Start Finish
Bill - 08:00 11:00
Dave - 08:00 13:00
and so on. They then want to be able to select a different day from a drop down list and it provide the same information. I think it can be done using match/index possibly and I have used this for other things in the past but whether it is because it's 16:30 in the afternoon and my brain is fried I don't seem to be able to get my head around it.
I have included an example and any help or suggestion would be great.
The shifts are in different colours for a reason, although this won't affect the start/finish time. But I had to find a way of differentiating between them automatically. Again, any better suggestions are welcome.
Bookmarks