My colleagues and me are looking for a way to have a combined calendar of our work shifts, to be able to have a merged and printable calendar for example in a format like this:
Our monthly work schedules are available in both Outlook and Google calendars. Usually one event per day covering our whole shift, occasionally separated into two or three events on a given day. We need to be able to see specific person's work pattern, preferably the whole month in a single row. At the moment our team is around 10 people, but this should be scalable to some extend.
I was thinking that we could share our Google Calendars, but there is no sensible display view available in web or phone app to see multiple calendars side by side. All the available views are more focused on the day, not the person. If there was an easy option to export the calendar into excel, that would also be good.
Any advice?