How to Separate Date and Time into Different Columns in Excel – 2 WAYS!
So... the boss wants you to separate a cell with date and time in excel into two different columns?
This video will show you two methods. Plus explain how dates and times are stored in excel.
⌚ TIMESTAMPS
0:00 How to Split Dates & Time into Different Columns Intro
0:07 Method 1- Using the Integer Function
1:22 Method 2 - Using Text to Columns to Split Date and Time in Excel
📢* FREE RESOURCES*
Mega Excel Keyboard Shortcut List
https://view.flodesk.com/pages/63bf31...
Quick Reference Guide
https://view.flodesk.com/pages/63bf2f...
🔥 THE PROF’S COLLECTION: https://theprofessorcubs.gumroad.com
🛠 RECOMMENDED TOOLS AND DISCOUNTS
NOTE: Please know I have experience with these products, and recommend them because they have been proven to be reliable and trustworthy, not because of the small commissions earned.
✅ InvideoAI https://invideo.sjv.io/professorcubs
Affiliate Disclaimer: This video/ description may contain affiliate links, which means that if you decide to purchase any products, we will earn a small commission to support videos on this channel. The price you pay is the same.
#ExcelFunctions #ExcelFormulas #DateandTimeInExcel
ABOUT PROFESSOR CUBS
🏆 My goal is to help you learn popular software apps so you can be more productive, save time in life, so you can spend it on activities that matter.
Some of the app tutorials include:
Microsoft Excel, Power BI, PowerPoint, OneNote, Word, Tableau, Audacity, Reaper and other popular software applications
🎓 My background: 25+ years in corporate training teaching both software and business skills, along with working in the financial business. Degree in Finance, along with a list of certifications that would bore you to tears.
🚀 I remember first learning technology, how confusing and overwhelming it can be. So I strive to make things simple, easy and fun.
Thanks,
Professor Cubs
Watch video How to Separate Date and Time into Different Columns in Excel – 2 WAYS! online without registration, duration hours minute second in high quality. This video was added by user Professor Cubs 23 January 2025, don't forget to share it with your friends and acquaintances, it has been viewed on our site 34 once and liked it 0 people.