Excel - Three Tips for Separating Date From Time | Split cell data

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

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 ---------------------------------

-- SOFTWARE USED ---------------------------------

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!

[cotejnfrs]

Thank you so much. This was to the point perfect for me. Thank you«!

[mazydrums]

woww.. thanks for making this video.. you saved my time and day :)

[shagungoel]

Hi, is it possible to host multiple zoom meetings at the same time from the same account?

[muhammadkamran]

Hi, is it possible to separate the currency symbol I.e € $ chf etc to identify the currency in the cell?

[davideastham]

Is there a way to remove a time zone in a formula? I'm trying to calculate the time between a start date and time and a submission date and time. Right now my spreadsheet also shows the time zone but I can't find a way to properly calculate without removing the time zone. - example: Start - 08/30/2021 08:33:53 AM EDT - submitted 08/30/2021 08:43:54 AM EDT. I've been using Find / Replace ( EDT) to get rid of it but it's a pain.

[SanjeevKumar-lxzi]

Sir,
I am creating on time delivery report
Data I have as below
Vehicle will arrive at delivery point on "day2" and this time slot
"9:00am to 11:00 am" in a cell

My vehicle arrived on "day2" time "10:30am"

So my delivery is on time, because its in slot time..

Please help how to make easier..

[sreejiths]

Hi,
When I open TSV file in excel it is coming as normal text and not like created spreadsheet. If I open the same TSV by Using Data > Get Data from Text / CSV it is opening in the proper way. Can you help me to open same the way as default.?

[DrJohnPollard]

Lot of fiddling around for failure of Excel not to have separate fields.