Hello, needing a macro to perform the following:
I have a sheet that ingests data from the web and then I parse out the data via a macro. What I need is in cell BG1, there will be four possible values in this cell, 00Z, 06Z, 12Z, 18Z. Each one is a time reference like 18Z is 18 UTC time. Based on which value is in BG1, I need make BE2=BG1, then add one hour and put that vlaue in BF 2, add another hour and put that value in BG 2.
I need this in a macro format as I have to clear the data often and the formulas will get deleted.