I am no expert in expert Excel. I hope someone can help me. I have a spread sheet that has 5 min price data. My goal is to ignore all time frame and extract only first hour (9:30 -10:30) High and and low. (First hour range)I am basically trying to come up with a formula for first hour range on Excel spread sheet. Column A = Date B= Time C=Open D= High E=Low F=Close I will appreciate any help. Thank you.