You are reading a single comment by @aggi and its replies.
Click here to read the full conversation.
London Fixed Gear and Single-Speed is a community of predominantly fixed gear and single-speed cyclists in and around London, UK.
This site is supported almost exclusively by donations. Please consider donating a small amount regularly.
aggi
What's the best way to use Excel for calendar and time stuff? (The correct answer isn't "don't"). I want to set it up and never see it again.
A team of 30 people need to say what they worked each day.
Obviously, the thing people want is a matrix of names down the side, date along the top, shift they worked written in words.
This is easily read but not so easily calculated from.
I'd like to set out
Date time on time off name
And then a nice long table, which can be easily pivoted to show a calendar and the number of hours worked a day.
But I know that won't work, because the people can't get their head around it.
What else can I do?