Hi,
I have the following format in excel.
Date OPEN HIGH LOW LAST_PRICE
2/26/2008 8:00 1154.63 1156.19 1154.15 1156.1
4/26/2010 8:20 1154.63 1156.19 1154.15 1156.1
....
5/01/2010 17:00 1154.63 1156.19 1154.15 1156.1
I want to write a formula that excludes any rows that are outside of 8:20 am till 4:00 pm time frame. I tried vlookup but with no luck. Please advise. Thanks.
Bookmarks