Forum Discussion
macro recording for recording and updating hour and minutes data to the current time
Range("E6").Value = Range("B6") + TimeSerial(Range("E10").Value, Range("E11").Value, 0)
If it worked for you, dont forget to flag it as solved.
Remember that hitting the like button is less costly than buying me a coffee.
thank you for the reply.
I tried using the formula but it dint work as expected, I guess there is something wrong in my syntax that I have used.
In the attachment I expected the time to increase by 2hours and 30 minutes but it is showing 12:30Pm, also I want the current date to change to next date once the time crosses 12:00Am.
Can you please help me with the syntax based on the file I have shared. It would be really helpful.
Thank you.
Range("E6").Value = Range("B6") + TimeSerial(Range("E10").Value, Range("E11").Value, 0)
If it worked for you, dont forget to flag it as solved.
Remember that hitting the like button is less costly than buying me a coffee.
Yes thank you so much this is what I was expecting.
One more thing if you can help to do would be great is to update the date as well as soon as the time crosses 12:00Am with reference to the current date.
For ex-: if the start time is 11:00Pm and start date is 1st Jan'21 and I want to update 10 hours and 30 minutes which means it goes to the next day 09:30AM on 2nd Jan'21 so the current date should display 02-01-2021.
Thank You.