How to Separate Date & Time in Excel

Hello, in A1 I have a date and time shown as 201008061730 (yyyymmddhhmm). How do I get the date element into B1 as 06/08/2010 and in C1 the time as 17:30? Analystman

3 thoughts on “How to Separate Date & Time in Excel

  1. Excel Geek

    Hello

    To get the date in the correct format enter the following formula in cell B1

    =MID(A1,7,2)&"/"&MID(A1,5,2)&"/"&LEFT(A1,4)

    To get the time in the correct format enter the following formula in cell C1

    =MID(A1,9,2)&":"&MID(A1,11,2)

    You can then pull these formulas down into subsequent cells.

    Thanks for writing!

Leave a Reply

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