Need formulas to pull date and time from 1 cell to 2
Perfect, thanks.
"T. Valko" wrote in message
...
Try this:
A1 = 11/6/2008 2:18:00 PM
For the date:
=INT(A1)
Format as Date
For the time:
=MOD(A1,1)
Format as Time
--
Biff
Microsoft Excel MVP
"Dan B" wrote in message
...
I have a report with date and time column. The data looks like this:
11/6/2008 2:18:00 PM
I need to pull the date into one cell and the time into another. How can
I do this when the date and time will vary in the number of characters?
i.e =left(a1,9) will miss part of the date if were another character
long, like 11/16/2006.
Thanks
|