Hello,

My work sheet contains occurances that take place at certain times of the day. My spreadsheet contains 2000 rows. Each row is an occurance. Each occurance has a particular time stamp associated with the occurance.

I'm attemtping to evaluate if the time of day falls into a time range. When I evaluate the time 07:31, this time would fall into the 0700-0800 time range. If the time was 09:31, it would fall into the 0900-1000 time range, etc. Consequently, I need to evaluate each specific time and return the range that this time would fall into.

The time stamp is in column A and there are 2000 rows. I'd like to return the time range "0700-0800" or "0800-0900", or "0900 - 1000" etc in column F

Thanks