3

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:

desired output format desired output format

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?

1
  • It has been a while and I am writing to see how things are going on with this issue. Have you had a chance to check the replies provided? Any update would be appreciated.
    – Christy
    Commented Aug 1, 2022 at 8:38

1 Answer 1

1

Are you using Outlook desktop client?

If so, we can see multiple calendars side by side as shown in the below figure by selecting the calendars you need.

enter image description here

In addition, we can also export the calendar to a CSV file via File>Open & Export>Import/Export.

3
  • 2
    Hmmm, if I don't find anything easier, this seems like a worthy solution, thanks!
    – Greg
    Commented Jul 27, 2022 at 9:33
  • Hi @Greg! If you think my reply is helpful to you, please remember to mark it as an answer. Warm thanks.
    – Christy
    Commented Jul 28, 2022 at 2:11
  • Sorry, I was just waiting to test it, but yes - not the easiest way I imagined but it works, thanks!
    – Greg
    Commented Aug 1, 2022 at 9:23

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .