Format date and time in Excel with VBA

Format date and time in Excel with VBA Copy data and time values from one sheet to the other Format time values to suit your needs with VBA.
Format time values in Excel with VBA Click this link to check out my one-on-one training For more help visit my website www.easyexcelanswers.com or email me at easyexcelanswersgmail.com. Contact me regarding customizing this template for your needs. Click for online Excel Consulting I am able to provide online help on your computer at a reasonable rate. I use a Blue condenser Microphone to record my videos here is the link Check out Crowdcast for creating your webinars I use Tube Buddy to help promote my videos Check them out Follow me on Facebook TWEET THIS VIDEO Follow me on twitter easyexcelanswers IG barbhendersonconsulting You can help and generate a translation to you own language this description may contain affiliate links.
When you click them I may receive a small commission at no extra cost to you.
I only recommend products and services that Ive used or have experience with. How to insert VBA code in Excel Sub formating Worksheetssheet1.Select Sheetssheet1.RangeA2:B23.Copy Destination:Sheetssheet2.RangeA2:B23 Worksheetssheet2.Select Date Column ActiveSheet.Columnsa:a.Select Selection.NumberFormat mdyyyy Time Column ActiveSheet.Columnsb:b.Select Selection.NumberFormat hh:mm:ss End Sub

Источник: rutube.ru