Windows 7 Forums
Welcome to Windows 7 Forums. Our forum is dedicated to helping you find support and solutions for any problems regarding your Windows 7 PC be it Dell, HP, Acer, Asus or a custom build. We also provide an extensive Windows 7 tutorial section that covers a wide range of tips and tricks.


Windows 7: Separating date and time in Excel Office 2007


12 Dec 2012   #1

Windows 7 64 bit
 
 
Separating date and time in Excel Office 2007

I have Office 2007 running on a Windows 7 64 bit Toshiba laptop. I am trying to separate the data and time in an Excel file in one column and put the date in one column and the time in another. I need a "how to" procedure to do that.

My System SpecsSystem Spec
.

12 Dec 2012   #2

Win 7 Pro x64 SP1, Win 7 Ult x86 SP1
 
 

Excel has formatting for Date and Time.
For column A use a Date format, and for column B use a Time format.
To copy the value from column A to column B a function in column B like this should work
= IF(A1="","",A1)
My System SpecsSystem Spec
13 Dec 2012   #3

Windows 7 64 bit
 
 

I tried that, but all the elements of the date and time are still there and that results in just what is seen in the viewing. In one column I want only the date data, and in the other column only the time data so those two different elements can be used separately in a variable data program.
My System SpecsSystem Spec
.


13 Dec 2012   #4

Win 7 Pro x64 SP1, Win 7 Ult x86 SP1
 
 

Yes, formatting only affects the displayed data.

To get the date, add a column with this formula
=IF(A1="","",TEXT(A1,"mm/dd/yyyy"))

To get the time, add a column with this formula (remove the am/pm if you want 24hr fmt)
=IF(A1="","", TEXT(A1,"hh:mm:ss am/pm"))
My System SpecsSystem Spec
20 Dec 2012   #5

Windows 7 64 bit
 
 

Thanks, DavidW7ncus, that works great on my laptop with Windows 7. I appreciate the help very much. Now if I can also figure out how to do it on a Mac OS X I will have both computers covered.
My System SpecsSystem Spec
20 Dec 2012   #6

Win 7 Pro x64 SP1, Win 7 Ult x86 SP1
 
 

Hello rcd1947,

You're welcome and thanks for posting back.

I don't have a Mac, so i don't know that can help with that.
What happens on the Mac?
Is the formula invalid, not work correctly, ... ?

If adding a screen print showing the problem is easier/better, this explains how to to this (Windows instructions).
Screenshots and Files - Upload and Post in Seven Forums
My System SpecsSystem Spec
Reply

 Separating date and time in Excel Office 2007




Thread Tools



Similar help and support threads for2: Separating date and time in Excel Office 2007
Thread Forum
Microsoft Office 2007 Excel Find and Replace Command Microsoft Office
Excel 2007 Date Factor Microsoft Office
Solved Office 2007 Excel File Association Microsoft Office
Time and Date issue - BIOS time and date reset after change in Win7 General Discussion
Excel 2007: a question about date and time manipulation Software
Date questions...Excel 2007 Microsoft Office
Excel and MS-Money 2005 date and time format display issue Microsoft Office

Our Sites

Site Links

About Us

Find Us

Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

Designer Media Ltd

All times are GMT -5. The time now is 06:31 PM.
Twitter Facebook Google+



Windows 7 Forums

Seven Forums Android App Seven Forums IOS App
  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33