Re: [users] Separate Time from DateTime

[JOE Conner]

Keith Clark wrote:

How could I separate the time from a date time cell in Calc?

Keith

It is actually simple, since the date/time cell actually contains a floating point number, just formatted for date/time.

The time is the decimal part.


I attached a calc file to illustrate.

Joe Conner, Poulsbo, WA USA

Keith.ods
Description: application/vnd.oasis.opendocument.spreadsheet

---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]