thatguytwo wrote:It is supposed to take a 13 digit 'UNIX' time stamp that exists in column A …
UNIX timestamps are never 13 digits. Any current timestamps are ten digits.
"Unix time passed 1000000000 seconds in 2001-09-09T01:46:40Z."
UNIX time
thatguytwo wrote:Im trying to get this macro to work
Trying to do this with an evil macro will make the job ten times harder. Just use a formula.
thatguytwo wrote:I did try having the cell highlighted, then clicking the function button, then copy pasting both
cell*TIMEVALUE("0:00.001")+DATEVALUE("1970-01-01") [or] cell/86400000+25569 and with both I get the error " #NAME?"
You have used a name that Calc does not recognize.
• In your formula replace "cell" with the actual cell address, say A1, or DX65537.
• DATEVALUE and TIMEVALUE are the function names in English. If your OpenOffice uses a different language, you have to use those function names. For example DATEVAL and TEMPSVAL for French, FECHANÚMERO and HORANÚMERO for Spanish. Use F1 help to determine function names in the installed language.
Begin your formula with an equal sign "=".
JeJe wrote:Have you tried cell*TIMEVALUE("0:00.001")+DATEVALUE("1970-01-01") ?
That formula is only for the
bogus time stamp from
bns002.OOConfused in topic
Convert UNIX timestamp. For a real UNIX timestamp you would use something like
=A1*TIMEVALUE("0:00:01")+DATEVALUE("1970-01-01") or
=E314/86400+25569.
thatguytwo wrote:Ive tried just inputting the simple =cells value/86400000+25569 in A1, and dragging the little square on the selection box down the whole column, but that doesnt work.
"It didn't work" isn't helpful in the forum because it tells us what did
not happen. Please
never use that phrase in a post. What
did happen?
• Error message? Give us the exact message.
• Your computer powered itself off? Probably not an OpenOffice problem.
• Strange results? Read the paragraph above about the bogus timestamp.
Attaching a document demonstrating the problem is almost always helpful for us and will get your problem solved more quickly. Often "it didn't work" means "it didn't do what I expected" and the real problem is that the program is behaving correctly but your expectations are incorrect. To help you solve the problem we need to know your expectations and your ultimate goal.
If this solved your problem please go to your first post use the Edit button and add [Solved] to the start of the title. You can select the green checkmark icon at the same time.
[Tutorial] Ten concepts that every Calc user should know
Mr. Programmer
AOO 4.1.7 Build 9800, MacOS 13.6.3, iMac Intel. The locale for any menus or Calc formulas in my posts is English (USA).