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.
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.
- thank you so much
