How to Split Date and Time in Excel




About this tutorial:

Video duration: 00:03:16
If you download data into Excel, one column might have the Date and Time combined in each cell.

In this short video you will see how to quickly split that value into separate date and time columns.

The first method uses a simple formula, and the second method is done without a formula — just a bit of typing.

Visit my website to get the sample Excel workbook.

VIDEO TIMELINE
0:00 Introduction
0:11 Split Date With Formulas
0:48 Get Time With Formula
1:30 Split Date Without Formulas
2:20 Get Time Without Formula
2:52 Get the Sample…

Post Author: OfficeTutes.com

Apple lover, ICT and LEAN consultant, MS Office lecturer My other website with video tutorials - Tutorials, guides and news for iPhones and iPads

19 thoughts on “How to Split Date and Time in Excel

    railzip

    (October 6, 2020 - 8:25 am)

    This saved me hours!

    True Healthcare Solutions

    (October 6, 2020 - 8:25 am)

    Genius! This is exactly what I needed. Thanks so much!

    Mike Bennett

    (October 6, 2020 - 8:25 am)

    God bless you!!! 😉

    Marcos

    (October 6, 2020 - 8:25 am)

    Thank you, helped me a lot!

    Youstina Mansour

    (October 6, 2020 - 8:25 am)

    Great Tips ! Thanks a million 🙂

    swati kumari

    (October 6, 2020 - 8:25 am)

    This is so good

    Caíque Aparecido Brite

    (October 6, 2020 - 8:25 am)

    It was such a simple but smart idea. Thank you.

    Caseydia1

    (October 6, 2020 - 8:25 am)

    Thank you so much! This was very helpful!

    abcdbd

    (October 6, 2020 - 8:25 am)

    Thank. You. So. Much! It's been a few years since I took the course, this was driving me nuts.

    MK DK

    (October 6, 2020 - 8:25 am)

    Thank you i appreciate that Good Small and Crisp Videos….with Sweet voice….

    V Sai S Narayana K

    (October 6, 2020 - 8:25 am)

    Thanks for the simple and easy solution.
    I would like to know how to seperate date from "1032973217/3044 / 3-4-2018
    " this, basically i want two columns in my spread sheet one showing date and other column showing the rest of the number. Kindly help me.

    Well-Paid Maids Support

    (October 6, 2020 - 8:25 am)

    Thank you for the great video! I was doing it manually before. Now that I know this. it'll save me so much time!

    Ervin Mark Suerte

    (October 6, 2020 - 8:25 am)

    How do I extract date-time to time without changing the embedded date? When I extracted the time from date-time, and re-extract the date from the extracted time, the extracted date becomes the default date which is january 0, 1900

    Current Problem:
    12/21/15 05:00 AM > 05:00 AM > 01/00/1900
    12/21/15 05:00 AM > 01/00/1900 > 12:00 AM

    Desired Output:
    12/21/15 05:00 AM > 05:00 AM > 12/21/15 or
    12/21/15 05:00 AM > 12/21/15 > 05:00 AM

    Muuip

    (October 6, 2020 - 8:25 am)

    Yes, Yes, Yes!Thank you! 🙂

    Rey Kuizon

    (October 6, 2020 - 8:25 am)

    Hi, I have a question. How do you split the date and time format? 2014.01.01 00:00:00

    NUH ZAKİR

    (October 6, 2020 - 8:25 am)

    Thank you for sharing.

    chinmay kamat

    (October 6, 2020 - 8:25 am)

    thanks

    killerhunk1

    (October 6, 2020 - 8:25 am)

    Never thought this would be so simple.

    Thanks for sharing ☺️👍

    ExcelIsFun

    (October 6, 2020 - 8:25 am)

    Great video!

Leave a Reply

Your email address will not be published. Required fields are marked *