I have a data feed that is time synchronized. Let's say that the data appears in cell C2. Please show me how to write the conditional statement(s) that will place the time in one minute increments in column d starting in D2, and the associated data for each of those minutes in column E, starting in E2.The result would look like this:
DATA Feed Time Data
1.3411 12:00:00 PM 1.3368
12:01:00 PM 1.3372
12:02:00 PM 1.3205
12:03:00 PM 1.3336
12:04:00 PM 1.3389
12:05:00 PM 1.3411
My team has spent nearly a whole day on this, and we've been unable to solve this. If you can help, please do. Thanks.
Bookmarks