to separate date and time formula

  • Thread starter Thread starter Soth
  • Start date Start date
S

Soth

Hi

How do you create a formula to separate date 04/12/2007 and time 00:00:00?

4/12/2007 00:00:00

Thank you,
Soth
 
If A1 contains your combined date and time, then...

For the date part: =INT(A1)

For the time part: =MOD(A1,1)

You will probably have to format the cells you put these formulas in to
display the date and time properly.
 
Wonderful - Thanks Rick



Rick Rothstein said:
If A1 contains your combined date and time, then...

For the date part: =INT(A1)

For the time part: =MOD(A1,1)

You will probably have to format the cells you put these formulas in to
display the date and time properly.
Click to expand...
 
If your data is in A1 and comprises a four digit date followed by
other text, then you can do this:

B1: =LEFT(A1,4)*1 to get the year
C1: =RIGHT(A1,LEN(A1)-4) to get the other text

Copy down as far as required.

Hope this helps.

Pete
 
Back
Top