Friday, December 4, 2009

OpenOffice Calc - turning strings to real Date and Time

OpenOffice.Image via Wikipedia
In Open Office Calc, how do you turn the string

'12/3/2009 11:06:35 PM

into the time value:

12/03/09 11:06:35 PM

internally represented by the float:


Here is the OpenOffice Calc formula:


coming from Excel, I get thrown for a loop by the semicolons.

Then use the Time/Date format of:


OpenOffice.Image via Wikipedia
This comes up enough so I would appreciate a place to cut-and-paste from. Now I have one! OpenOffice rocks!


Here is another example - starting with the original string containing the date


This is the formula to turn it into a proper OpenOffice Calc date:


Here is the format string:


To get the final result:


Probably the next one I post will have funky time data too... stay tuned...

Reblog this post [with Zemanta]

No comments: