Poll

Aboot this blog

This blog is a cross between a scrapbook and a diary. I hope you find something here of interest. If you’d like to keep up with things as I see them then you can subscribe to my news feed by clicking the icon below:

feed-icon-28x28.png

DISCLAIMER

Please note that any reviews/recommendations are based solely on my own experience and does not constitute a guarantee that you will have the same experience. Please do your own research before parting with any money - the risk is all yours!

The Briticiser

Looking for my world famous US to GB English spelling converter?

THE “BRITICIZSER”

www.us2uk.eu

IT’S HERE

Tags

  Family     Utilities     Equipment     Odds and Sods     Windows     Education     VBA     Flatpress     Hardware     Excel     Browsers     Word     Bookmarks     Reviews     PHP     Overcoming Disabilities     Acrobat     Tutorials     News     Software         Bits and Bobs     Plausible Lies  

Find me on Facebook

facebook-icon-28x28.pngVisit my Briticiser Facebook Page to keep up with things here - lots of reviews of stuff I’ve really used and also all kinds of helpful computer tips with a heavy bias towards SAVING YOU TIME.

Excel tip - Converting Unix Timestamps

Permalink: http://paul.us2uk.eu/?x=entry:entry140512-154624

imageYou may find the formula below useful if you are importing dates into Excel from a list where the dates have been stored as a UNIX timestamp. Some of my web application PHP scripts store numbers this way, hence the need to remind myself here of how to convert them to readable dates:

=(A1/86400)+25569+(-5/24)

Please remember that the above formula returns a date/time serial number, so you need to apply a number format to make it readable as a date and time. Simply select the cells you want to format and press Ctrl+1, then choose a date or custom format.

The standard format I use (to avoid any misunderstanding between international users) is a custom format “dd-mmm-yyyy” which will display a date like 12-May-2014.

Credit goes to www.spreadsheetpage.com for this tip.

Support our caregiving

If you found anything on this site of use, interesting, or even mildly amusing then please consider dropping a few pennies in the jar to help us to take care of our disabled son who contracted encephalitis in 2007 at the age of 6 and who is now confined to a wheelchair. He is getting bigger as his mother and I get older, imagine that, please. Every penny we collect goes towards his upkeep, and towards his future care requirements.

Thank you.

Support our caregiving

Support our caregiving

If you found anything on this site of use, interesting, or even mildly amusing then please consider dropping a few pennies in the jar to help us to take care of our disabled son who contracted encephalitis in 2007 at the age of 6 and who is now confined to a wheelchair. He is getting bigger as his mother and I get older, imagine that, please. Every penny we collect goes towards his upkeep, and towards his future care requirements.

Thank you.