alex_boothby
In Runtime
- Messages
- 317
Hi there,
I have spemt hours trying to do this to no avail.
Basically we have a water leak on site and we have a smart meter that outputs all flow data in intervals of 15mins for the past 2-3 years. So as you can imagine, 3 years split into 15mins is a lot of data!
Basically we are interested in 02:45:00 in the morning (this is time formatted in excel). I want to extract each 02:45:00 from every day. As at this time of day the flow should be close to 0! but it is not!
So I want to be select each each cell in the row that contains 02:45:00. This way I can copy the flow data that is in the same row as the time and then paste into another sheet so I can play with it (make graphs etc).
Is there a way to search and select each row that contains 02:45:00?
I have used VBA (copied someone elses) that selects every 95th row (this is the amount of cells between each 02:45:00), but this gets messed up with day lights saving times also for some reason there are some times missing on certain days so then its not every 95th row therefore messing it up for each latter 02:45:00! So it took me ages to correct for these faults and that was just for Jan-Dec this year! Would take far to long for 2013-current date.
I will kiss anyone who can help. Or wont depending on their preference...
I'm pulling my hair out!
I have spemt hours trying to do this to no avail.
Basically we have a water leak on site and we have a smart meter that outputs all flow data in intervals of 15mins for the past 2-3 years. So as you can imagine, 3 years split into 15mins is a lot of data!
Basically we are interested in 02:45:00 in the morning (this is time formatted in excel). I want to extract each 02:45:00 from every day. As at this time of day the flow should be close to 0! but it is not!
So I want to be select each each cell in the row that contains 02:45:00. This way I can copy the flow data that is in the same row as the time and then paste into another sheet so I can play with it (make graphs etc).
Is there a way to search and select each row that contains 02:45:00?
I have used VBA (copied someone elses) that selects every 95th row (this is the amount of cells between each 02:45:00), but this gets messed up with day lights saving times also for some reason there are some times missing on certain days so then its not every 95th row therefore messing it up for each latter 02:45:00! So it took me ages to correct for these faults and that was just for Jan-Dec this year! Would take far to long for 2013-current date.
I will kiss anyone who can help. Or wont depending on their preference...
I'm pulling my hair out!