Hello everyone
I'm going little nuts here
A1 has value 15 in it. (integer, no decimals)
I need VBA to dim this value as hh:mm:ss and then subtract 10minutes from it
How close am I?
Thank you in advance,
James
I'm going little nuts here
A1 has value 15 in it. (integer, no decimals)
I need VBA to dim this value as hh:mm:ss and then subtract 10minutes from it
How close am I?
Code:
Sub timechange
Dim aaa as Date
aaa = Range("A1").value + Timeserial(0,-10,0)
Thank you in advance,
James