We frequently have the date and time in Excel in the same cell. For example, 8/20/2023 9:30 pm. If you want to split them into two columns, there are several methods in Excel. Flash Fill, one of my favorite Excel features, will work, another option is to use the INT function in Excel. INT is for Integer. Using a PivotTable, we can also summarize the data, even with the date and time together.
Split date and time with the INT function
If the date and time are in cell A2, B2, to get the date, type =INT(A2). The INT function gives your whole numbers. The date and time together are decimals. When you use INT it gives you the whole number and ignores the decimal or the time.
Example: 8/5/2023 6:00 PM is 45,158.75. Using INT returns 45158.00 or 8/5/2023.
Flash Fill Videos by Chris Menard
Advanced Flash Fill - Lose prefix, suffix, and middle initial ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-Qr4JwW9MKeI.html
Flash Fill in Excel ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-tYlJddCqikI.html
One difference between using Flash Fill and INT is INT function will update if the original cell changes; Flash Fill will not automatically update.
#msexcel #exceltraining #chrismenardtraining #chrismenard
And make sure you subscribe to my channel!
Chapters:
00:00 Introduction
00:39 Method 1
02:00 Method 2
06:09 Method 3
08:57 Closing remarks
-- EQUIPMENT USED ---------------------------------
○ My camera - amzn.to/3vdgF5E
○ Microphone - amzn.to/3gphDXh
○ Camera tripod - amzn.to/3veN6Rg
○ Studio lights - amzn.to/3vaxyy5
○ Dual monitor mount stand - amzn.to/3vbZSjJ
○ Web camera - amzn.to/2Tg75Sn
○ Shock mount - amzn.to/3g96FGj
○ Boom Arm - amzn.to/3g8cNi6
-- SOFTWARE USED ---------------------------------
○ Screen recording - Camtasia - chrismenardtraining.com/camtasia
○ Screenshots - Snagit - chrismenardtraining.com/snagit
○ RU-vid keyword search - TubeBuddy - www.tubebuddy.com/chrismenard
DISCLAIMER: Links included in this description might be affiliate links. If you purchase a product or service with the links I provide, I may receive a small commission. There is no additional charge to you! Thank you for supporting my channel, so I can continue to provide you with free content each week!
13 июн 2022