Hello all,
I'm having a bit of trouble getting a line of code to work. I want to grab a time value from the worksheet (formatted in hh:mm:ss), round it up to the nearest minute, then add another full minute to it.
In the worksheet, I've used this, which works fine, but I'd like it handled by VBA so I can free up the cell. C1 is the source cell with the time value:
=(CEILING(C1,"00:01:00"))+"00:01:00"
In VBA, I've been trying to use:
Doesn't like it.Please Login or Register to view this content.
Anyone point me in the right direction?
Ta in advance.
Bookmarks