How to convert UNIX datetime value to date/time string in OpenOffice Calc or Excel

To convert a UNIX datetime value to date/time string in OpenOffice Calc or Excel use this formula (assumes your datetime stamp is in the A1 cell of the current spreadsheet): =A1/86400+DATEVALUE(“1/1/1970”) If you want to test the above you may use the following simple C program: ======= #include <stdio.h> #include <stdlib.h> #include <string.h> #include <time.h> […]

Continue reading


Help! Unable to automount my usb flash disk!

PROBLEM: On certain Linux distributions removable media (USB flash drives, CD’s,…) are auto-mounted by default and all users can read and write to them (if media is writeable of course). On others, inserting a removeable media results in an error message similar to Failed to mount “200GB Volume”, e.g. an error message from your file-manager […]

Continue reading


How to make ‘man’ or ‘less’ paged text not disappear from screen after exit?

Problem: Depending on your Linux distribution, the text displayed by the ‘man’ command  (or any other text piped into ‘less’ for that matter) may stay on your screen upon exit from man/less or be cleared from your screen upon exit. Many people find it useful to have the man page text stay on the screen, […]

Continue reading