2008/5/25, Dean Allen Provins, P. Geoph. <[EMAIL PROTECTED]>:
>
> Allen:
>
>
> On Sat, May 24, 2008 at 09:57:14PM -0700, Allen wrote:
> > Hi gang,
> >
> > I'm doing a study of spam and I need to break the date & time
> > field I'm getting from log files into separate date fields and
> > time fields. Currently it is all one: "05/13/08 12:32 PM" I need
> > it to be: "05/13/08" and "12:32 PM"
> >
> > Am running OO 2.4 on Windoze and Linux.
> >
> > Thanks,
> >
> > Allen
> >
> > There are only 11 types of people in the world; those who
> > understand binary; those who don't; and those who could care
> > less, they just want the g^&d$%^ computer to work!
>
>
> Assuming "05/13/08 12:32 PM" is in cell C10, add the folowing to cells
> E10 and F10 respectively:
>
> =LEFT(C10;9) & """" and ="""" & MID(C10; 11; 9)
>
> This will fill those two cells with "05/13/08" and "12:32 PM"
> respectively.
>
> Dean
>
> --
>
Or just, if date and time is in A1, just input =A1 in B1. Then format A1 as
date and B1 as time...
