Forum Discussion

UG_1180's avatar
UG_1180
Copper Contributor
Sep 28, 2021
Solved

macro recording for recording and updating hour and minutes data to the current time

Hello Microsoft Tech community, I have attached a screenshot, if I press the Enter data button it should add the hours and minutes values that are entered in the assigned cells to the current time c...
Macros and VBA
  • Juliano-Petrukio's avatar
    Juliano-Petrukio
    Sep 30, 2021

    UG_1180 

    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.

     

leg034bcpsorg's avatar
leg034bcpsorg
Copper Contributor
Sep 30, 2021

1thank you guys so much take a picture of my work picture a camera a camera camera camera camera

smi Daisy Liangthankthank youthank you so much I said lainDaisy PeytonCaden CadenEnglish so much so much my Chanel and Mason Mason C Mason's taking you guys so much thank you for the book I see you guys tomorrow morning I-85 at 8:30 I-85 845if he has so much as you guys next videofamous tube kids famous tube kids Batman suit kids famous to get famous two kids Batman suitcasessis vs. bro Ronald sis versus bro versus sis versus brocall Mike by Mike by Mike and MikeElsa and Anna Elsa and Anna for school tomorrow on Thursday at 8:45 at 8:30 thank you guys so much I'll see you guys tomorrow have a good night TV thank you guys so much I hope you guys have a great weekend if you're free on Friday thank you guys so much have a good weekend thank you so much you're the best one in the whole wide world by Melissa Ramsey tomorrow at 7 I'm miserable around by miserable well Daisy by Daisy Daisy Daisy Daisy and land land land land land land so much power we have a good day as yes Mom

  1.  

Resources