Excel Forum

Pivot Table: Creating Shift Schedule availability

David Allender

New Member

Members

Forum Posts: 1

Member Since:
September 15, 2021

Offline

September 15, 2021 - 2:05 am

Is it possible to create a pivot table in which I have a list of employees that we can can quickly see on a pivot table who is available at what time of the day? Roughly looking at a list of 150 employees that work a variety of different shifts.

would like to be able to click the day of the week, the hour and the pivot table would show me the employees that are available at specific time.

Mynda Treacy

Admin

Forum Posts: 4443

Member Since:
July 16, 2010

Offline

September 15, 2021 - 7:58 pm

Hi David,

Welcome to our forum! You could use the filters on a Table to filter for employees that fall between date and time ranges. You can't do this with Slicers, but the filters on the table have more advanced filter options.

Mynda

Forum Timezone: Australia/Brisbane

Most Users Ever Online: 245

Currently Online: Brian Pham, baber Tufail, drsven

Guest(s) 9

Currently Browsing this Page:
1 Guest(s)

Top Posters:

SunnyKow: 1432

Anders Sehlstedt: 870

Purfleet: 412

Frans Visser: 346

David_Ng: 306

lea cohen: 219

A.Maurizio: 202

Jessica Stewart: 202

Aye Mu: 201

jaryszek: 183

Newest Members:

drsven

Annie Witbrod

wahab tunde

Cong Le Duc

Faisal Bashir

Ivica Cvetkovski

Blaine Cox

Shankar Srinivasan

riyepa fdgf

Hannah Cave

Forum Stats:

Groups: 3

Forums: 24

Topics: 6205

Posts: 27211

Member Stats:

Guest Posters: 49

Members: 31880

Moderators: 3

Admins: 4

Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea, FT

Moderators: MOTH Support, Velouria, Riny van Eekelen