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
Bookmarks