Image via WikipediaIn 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:
=DATEVALUE(SUBSTITUTE(A2; "'"; ""))+TIMEVALUE(SUBSTITUTE(A2; "'"; ""))
coming from Excel, I get thrown for a loop by the semicolons.
Then use the Time/Date format of:
MM/DD/YY HH:MM:SS AM/PM
Image via WikipediaThis 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...