Last week I reached out to a few readers asking them if they are struggling with anything in Excel. One of the readers (Malclom) wrote a very interesting problem about finding shift timings
Let’s see if you can knock it down! Ready for it?
The Problem
We have been given a Start Time for 30 employees which could be any time of the day. The problem is to categorize the Start Time into either of the 3 buckets. If the Start Time is
- Between 10 PM – 5:59 AM you should write Shift 1
- Between 6 AM – 1:59 PM you should write Shift 2
- Between 2 PM – 9:59 PM you should write Shift 3
This is how the result should appear
Post your answers in the Comments
If you can come up with a solution based on VBA, Formulas or any other trick that cut down manual work, please put down your answers in the comments below! Looking forward to your solutions
Hungry for more Excel Challenges
- Draw a Chart with this Data – The solution is here
- Play a game to pick the right chart – The solution is here
- Re-Organise Data for a Pivot Table
