Return values between time range

Question

Hi, I'm struggling to produce an idea of how to return value and then run certain calculations.

In the example below, I have two columns. Time and numbers

• first, I would like to return values between 11:00:00 and 12:00:00, all the way down (the Tiem column represents 5-minute intervals of 24 hours),

To be more specific I would like to return values for each day, between 10:00:00 and 11:00:00

• second, out of the returned values, I would like to return to the next columns only values that are greater than the top cell.

(the table below is an example of a few thousand data points that represent days)

10:50:00	2369.2
10:55:00	2368.3
11:00:00	2370
11:05:00	2369.2
11:10:00	2368.2
11:15:00	2370.9
11:20:00	2370.2
11:25:00	2366.3
11:30:00	2367
11:35:00	2367.8
11:40:00	2371
11:45:00	2368.7
11:50:00	2367.3
11:55:00	2374.2
12:00:00	2373.3
12:05:00	2367.8
12:10:00	2367.8
12:15:00	2364.4
12:20:00	2361.9

Answer 1

I am downloading the raw data once again. I'll post it soon

Answer 2

Trying to work on your file online, but connection been lost; did you remove it?

You'll see that I had a go at correcting the dates and started a few formulae...

Answer 3

The dates are still a mess.

1. If it's from a txt file, provide a link to the text file, not an Excel file.
2. If you're pasting into Excel, you can prevent Excel from converting by formatting the receiving column A as Text before pasting. I'll handle the date conversion.

I can't correct the file you've given easily because Excel has converted some dates correctly and others incorrectly and it's difficult to establish which is which.

Answer 4

TS.xlsx

Answer 5

You might need to do something (make it public?):