Hi all,
Got asked to do another spreadsheet macro at work today...*sigh*... Your help is once again needed.
I've got tens of thousands of data rows.
It's taking measurements everyday of the year. At 10 minute intervals.
Problem is, the date reset...So now the data says it goes from 1-01-2010 to 1-01-2004.
There are time stamps every 10mins of each day too.
So I was trying to write a macro something like this:
If Range("Column G") = "00:00" Then Range("Column A") = "2-01-2012".
End If
So basically I was trying to write a macro to say when Column G = 00:10 (First measurement after Midnight), advance the previous date (adjacent in column A) by one day.
Cheers,
Chris
Bookmarks