On 15/07/2008 22:32, Keith Clark wrote:
How could I separate the time from a date time cell in Calc?
Keith
Depends.
1. For appearances only: first copy the value to another cell; then
format one copy as a date choosing a format that doesn't show the time
and format the other as a time choosing a format that doesn't show the date.
2. To really split the value, assume it's in A1 then
the date part is =DATE(YEAR(A1);MONTH(A1);DAY(A1))
the time part is =TIME(HOUR(A1);MINUTE(A1);SECOND(A1))
Having assigned the values to cells you can format them as you like,
possibly for example not showing the seconds.
--
Harold Fuchs
London, England
Please reply *only* to [email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
