A$1 = 1535 (ie the time 15:35). I can't change the format.
To add 1-minute increments in successive rows in the same column, I use:
A2=A$1+1
A3=A2+1
A4=A3+1
etc.
The problem is when I get beyond 1559 - it continues 1560, 1561, etc. How can this be solved?
Thank you.
Grant.
Bookmarks