On Tue, 2008-07-15 at 22:54 +0100, Harold Fuchs wrote: > 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. > >
My use is for function and not show. I should have specified! Thanks for another way to do it. I appreciate the fast help here. Keith --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
