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