How to Separate Date and Time in Excel using Text to Columns, Formula & Power Query

Подписаться 99 тыс.

Просмотров 68 тыс.

50% 1

Download the featured file here: www.bluepecantraining.com/wp-...
In this video I show three different methods for splitting date and time in Microsoft Excel.
Table of Contents:
00:00 - Introduction
00:07 - Text to Columns method
00:56 - Formula method
03:14 - Power Query method
------------------------

Хобби

Опубликовано:

3 июл 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 26

@kingdomofisrael6486 Год назад

You did exactly what I have been searching for the past week and a half. Thanks mate!

@countduckula9977 2 года назад

Thanks Chester for showing 3 different ways to the same thing - very useful.

@data_kom 2 года назад

Your video just did the magic I needed to progress with my data cleaning. Thanks.

@IvanCortinas_ES 2 года назад

I love Power Query. Thanks for this tutorial Chester!!!

@LizMAlex 2 года назад

Very easy to follow. Thanks for providing options.

@aliaformo9487 11 месяцев назад

Great video, just what I was looking for! Thank you so much!

@ALSAEC Год назад

This was a Huge help, thank you!

@jonathannali7682 2 года назад

Thank you sir. This certainly worked for me.

@manishankaryadav7307 2 года назад

Thank you for saving time.

@reddit_tea 2 года назад

Thank you so much!

@mohamedel-sharkawy5537 Год назад

Thank you for the great service you are the best ❤️🌹

@wallieshere Год назад

thanks so much.. I was using Power Query and splitting the column. I kept getting the Time in 12hour format.

@alihanafiah2124 2 года назад

thank you very much sir for your tutorial..

@A-R-K37 7 месяцев назад

Thanks for your help dear

@user-tc8lt5yj6n 4 месяца назад

Thanks for your video

@teoxengineer 2 года назад

And we can use some cases "Flash Fill". Thank you for those tips

@adhurimuka 2 года назад

Alternatively, for date you can use INT and to get time, you can subtract the two values. Thank you for the video

@ZeuSonRed Год назад

Thisis exacly what I need it The formula mrthood thanks

@AndrewMacDonald-sy6us Год назад

Legend!

@wayneedmondson1065 2 года назад

Great one Chester! I've always used INT and MOD to do this. Great to see some alternatives. Thanks for demonstrating! Thumbs up!!

@YGBHawk Год назад

How do you extract date from text, e.g "1952 J.W. Robinson" I have a list of names and dates in this format that I need to separate. No guides anywhere.

@helpfulsite1969 Год назад

good

@ChesterTugwell Год назад

Thanks

@emekaemmanuel5258 2 года назад

What if you have 2 dates in a column? for exam a column that has a date like this 01/28/2010-01/28/2011. How can i split the dates into 2 columns 01/28/2010 and 01/28/2011