I need some help and advice to start using advanced flirting on a schedule
I have worked out the questions i want to query/filter about:
List everyone who is working at that time range on a certain day
Employee / Day /Time
Chanyeehon/ Tuesday / 9am to 3pm
List everyone that can work on Monday that can work between 9 to 5
-I have 22 employee first names
-Each employee works 1 to 2 days each week
-the time range
Should i use a start time column and an end date column?
What kind of format should i use?? i.e Employee / Day? / Time...
But each employee works at least 2 shift a week
should i use one sheet per day?
or is it just possible to just one sheet for all days and time