View Single Post
Old 11-16-2018, 03:53 PM   #64
Superfraggle
First Line Centre
 
Join Date: Nov 2003
Location: Calgary
Exp:
Default

Probably too later, and not totally sure I understand what you are trying to do, but my guess is you just want to advance by one hour every row going down?

If so, in cell B2, enter both the date and the time (8/1/2018 1:22:52 PM). Format it so that it only shows the time. In A2, just refer to B2 (=B2) and format that one to show the date.

In cell B3, just enter the formula (=B2+(1/24)). That will advance it by one hour. Then just copy the formulas in the two columns down until you get where you want to be.
Superfraggle is offline   Reply With Quote