kmfkstation.blogg.se

Now, we should point out that LibreOffice is quite powerful, and in most cases, it can perform the same actions as Microsoft Office, albeit a little differently. Encrypt & add Passwords to LibreOffice documents Furthermore, it’s open-source, so if this is something you prefer, then you should feel right home with this piece of software. If the format of H3 is set to such time format.LibreOffice is the best alternative to Microsoft Office right now, and guess what? This software is free to download and use. So, to get the local time, if the Time zone is Pacific standard time GMT-8, we need to add (-8) hours.

Of course, since Unix epoch time is always based on UTC (+0 meridian), the result above needs to be shifted as many hours as the local Time zone is distant from UTC. With that change, the formula gives: H3 = H2/1000/86400+25569 = 43130.75Ĭhange the format of H3 to date and time (Format -> Cells -> Numbers -> Date -> Date and time) and you will see: 18:00:00 H3 = H2/86400 + ( DATE (1970,1,1) - DATE(1899,12,30) )īut the epoch value you are giving is too big, it is three zeros bigger than it should.

Get the correct number (last formula): H3 = H2/(60*60*24) + ( Difference to since in days )

Select Format -> Cells (a panel opens) -> Numbers - Date - Format (select one)Įxpand width of cell if not wide enough to show the desired format (hint: three # appear).

Select Format -> Cells (a window opens) -> Numbers - Date - FormatĬhange format of the H3 cell to the required date format:.

Select Format -> Number Format -> Date.

If H2 contains the number to transform ( 1517335200000).Ĭhange format of cell H3 to date.