Hello, I have a CSV file generated from sources that log data every 15 minutes. Unfortunately the source may be off by one second and puts the data on a new row, so I get something that looks like this:
Capture1.PNG
When I would like to ignore the small 1 second time difference to look like this:
Capture2.PNG
The file contains a large amount of data so manually editing the file is not an option. Can anyone help me with how to programmatically solve this problem? Thanks.
Hi and welcome to the forum
Please do not upload a picture of your file...rather, upload a sample of your workbook, showing what data you are working with, a few samples of your expected outcome is (manually entered is ok) and how you arrived at that. (exclude sensitive info). Pictures are pretty much impossible to edit, and no-one wants to re-type your data for you
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Hi, sorry about that and thanks for the welcome. Here is the sample workbook from the original post.
Book1.xlsx
I need the first small set of data to become the second small set of data by ignoring the one second time difference or rounding to the nearest minute.
Thanks!
thanks for the file
Try this, copied down and across. You will obviously need to adjust the ranges to suite...
=SUMIFS(B$2:B$5,$A$2:$A$5,">="&$A9,$A$2:$A$5,"<"&$A10)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks