How to Handle Timing Wise ?

[excelstarter2014]

i have 1500 data of different dates with different timings in column A; Based on "timings" need to print the value in Column B. [ For Ex : Printed Value in column B need to be as Phase 1 or Phase 2 or Phase 3 or Phase 4 based on timings.

Timings are : In between 10:35 to 12:00 ; Phase 1 should print in Column B.

Timings are : In between 12:01 to 15:10 ; Phase 2 should print in Column B.

Timings are : In between 15:11 to 16:10 ; Phase 3 should print in Column B.

Timings are : In between 16:11 to 18:10 ; Phase 4 should print in Column B.

For example : Data in Column A are listed as below :

Thu 08/08/2013 10:35

Fri 09/08/2013 12:01

Sat 10/08/2013 07:04

Sun 11/08/2013 13:10

Thu 12/09/2013 18:15

Tue 13/08/2013 16:09

Wed 14/08/2013 16:19

Sun 15/12/2013 11:04

Fri 16/08/2013 10:37

[AlanY]

the attached should work but with a few extra helper columns, you can either hide them or combined them into a long one.

[excelstarter2014]

Dear Alan Y, Thanks for your reply, i have a little doubt if the scenario was like below for phase 1, phase 2 and phase 3, could you please provide solution for the below scenario?, change made in timings of phase 1, phase 2 and phase 3

Scenario :

i have 1500 data of different dates with different timings in column A; Based on "timings" need to print the value in Column B. [ For Ex : Printed Value in column B need to be as Phase 1 or Phase 2 or Phase 3 or Phase 4 based on timings.

Timings are : In between 10:35 to 12:00 ; Phase 1 should print in Column B.

Timings are : In between 11:49 to 15:10 ; Phase 2 should print in Column B.

Timings are : In between 14:11 to 16:10 ; Phase 3 should print in Column B.

Timings are : In between 15:20 to 18:10 ; Phase 4 should print in Column B.

For example : Data in Column A are listed as below :

Thu 08/08/2013 10:35

Fri 09/08/2013 12:01

Sat 10/08/2013 07:04

Sun 11/08/2013 13:10

Thu 12/09/2013 18:15

Tue 13/08/2013 16:09

Wed 14/08/2013 16:19

Sun 15/12/2013 11:04

Fri 16/08/2013 10:37

[excelstarter2014]

Re: How to Handle Timing Wise ?
Dear Alan Y, Thanks for your reply, i have a little doubt if the scenario was like below for phase 1, phase 2 and phase 3, could you please provide solution for the below scenario?, change made in timings of phase 2, phase 3 and phase 4

Scenario :

i have 1500 data of different dates with different timings in column A; Based on "timings" need to print the value in Column B. [ For Ex : Printed Value in column B need to be as Phase 1 or Phase 2 or Phase 3 or Phase 4 based on timings.

Timings are : In between 10:35 to 12:00 ; Phase 1 should print in Column B.

Timings are : In between 11:49 to 15:10 ; Phase 2 should print in Column B.

Timings are : In between 14:11 to 16:10 ; Phase 3 should print in Column B.

Timings are : In between 15:20 to 18:10 ; Phase 4 should print in Column B.

For example : Data in Column A are listed as below :

Thu 08/08/2013 10:35

Fri 09/08/2013 12:01

Sat 10/08/2013 07:04

Sun 11/08/2013 13:10

Thu 12/09/2013 18:15

Tue 13/08/2013 16:09

Wed 14/08/2013 16:19

Sun 15/12/2013 11:04

Fri 16/08/2013 10:37

[AlanY]

Dear Alan Y, Thanks for your reply, i have a little doubt if the scenario was like below for phase 1, phase 2 and phase 3, could you please provide solution for the below scenario?, change made in timings of phase 1, phase 2 and phase 3

Scenario :

i have 1500 data of different dates with different timings in column A; Based on "timings" need to print the value in Column B. [ For Ex : Printed Value in column B need to be as Phase 1 or Phase 2 or Phase 3 or Phase 4 based on timings.

Timings are : In between 10:35 to 12:00 ; Phase 1 should print in Column B.

Timings are : In between 11:49 to 15:10 ; Phase 2 should print in Column B.

Timings are : In between 14:11 to 16:10 ; Phase 3 should print in Column B.

Timings are : In between 15:20 to 18:10 ; Phase 4 should print in Column B.

For example : Data in Column A are listed as below :

Thu 08/08/2013 10:35

Fri 09/08/2013 12:01

Sat 10/08/2013 07:04

Sun 11/08/2013 13:10

Thu 12/09/2013 18:15

Tue 13/08/2013 16:09

Wed 14/08/2013 16:19

Sun 15/12/2013 11:04

Fri 16/08/2013 10:37

i see you have time overlapped. so which phase should that be for 15:00, say?

[excelstarter2014]

yeh time overlapped; if the student came to my school in the below timings ; phase need to print accordingly;

Student Visiting to the the Class if Timings : In between 10:35 to 12:00 ; Phase 1 should print in Column B.

Student Visiting to the the Class if Timings : In between 11:49 to 15:10 ; Phase 2 should print in Column B.

Student Visiting to the the Class if Timings : In between 14:11 to 16:10 ; Phase 3 should print in Column B.

Student Visiting to the the Class if Timings : In between 15:20 to 18:10 ; Phase 4 should print in Column B.

[AlanY]

that should work