Find the correct shift timing - Excel challenge

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

Find the correct shift timing - Excel challenge 1

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

Find the correct shift timing - Excel challenge 2

 

DOWNLOAD THE EXCEL FILE HERE

 

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

  1. Draw a Chart with this Data  – The solution is here
  2. Play a game to pick the right chart – The solution is here
  3. Re-Organise Data for a Pivot Table

 



Topics that I write about...






Download Smart Ebooks on
Excel and Power BI