Time ranges in Excel Modelling

[Mooboos]

Hi There

I have a three shifts
06:00-14:00- Morning
14:00-22:00- Evening
22:00-06:00- Nights

I have a range of times E2 Column such as
18:44
21:49
02:59
06:54
(ect)

I want to return in the column next to the time if the time falls in-between the shift times whether its a Morning, Evening or night shift?

Can anyone help?

 

[borkarrr]

Hi FormR,

can you please tell me how to insert those cells like (that excel sheet sort of thing) you have done in the above post?
i was wondering for quite some time,how ppl do that


Btw im able to copy paste both the formulas correctly

 

[FormR]

can you please tell me how to insert those cells like (that excel sheet sort of thing) you have done in the above post?

Hi Borkarrr,

Take a look here:

http://www.mrexcel.com/forum/about-board/508133-attachments.html

I use the "MrExcel HTML maker" there are detailed instruction in post#3 of the above link on how to install and use it and there is also a link to a youtube video that one of the members here made.

 

[borkarrr]

Thanks...

 

[Mooboos]

Worked Thank you so much for your time

 

[FormR]

Worked Thank you so much for your time

Glad we could help

 

[MARK858]

Deleted. Missed posts looking on phone. My bad