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!
If you import the date and time, or type them, Calc should convert the
results to the numerical equivalent with the date being the integer
portion and the time being the decimal portion. If you have the date
and time combination in column A, then make the cells in column B and C
as follows:
A B C
1 01/01/08 12:00 AM =int(A1) =A1-B1
2 01/01/08 12:00 PM =int(A2) =A2-B2
3 01/02/08 08:12 PM =int(A3) =A3-B3
Format column B as the date and column C as the time and you should see
the following:
01/01/08 12:00 AM 01/01/08 12:00 AM
01/01/08 12:00 PM 01/01/08 12:00 PM
01/02/08 08:12 PM 01/02/08 08:12 PM
Regards,
Gene K.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]