How to convert full date/time to timestamp?

What format is this timestamp: 2456799.87848174 ?

I have an excel sheet of data extracted from a SQL database. A column in the table is headed "time" and has the following format: 2456799.87848174. How do I convert this to a human readable date and time, or even a unix timestamp? I think the following match, very roughly, to these dates and times if it helps 22/5/14 - 0900: 2456799.87848174 22/5/14 - 1000: 2456799.89098252 22/5/14 - 1100: 2456799.90347924 22/5/14 - 1200: 2456799.92431562
Answer:

These appear to be in http://en.wikipedia.org/wiki/Julian_day, possibly from SQLite.

Morsey at Ask.Metafilter.Com Visit the source

Was this solution helpful to you?

Other answers

Inside Excel, =cell-2415018.5 and format as date/time gives you the timestamp.

effbot

Here is an online http://www.onlineconversion.com/julian_date.htm, put the long number in the Julian date field and click Calculate.

bottlebrushtree

Brilliant, the converter is exactly what I needed - Thank you :)

Morsey

Related Q & A:

What is the AMF format?Best solution by Stack Overflow
What's the easiest way to scrape residential phone numbers and names into .csv format?Best solution by Quora
What do I need to transfer a tape format into a digital format?Best solution by wikihow.com
What format is a DVD?Best solution by Yahoo! Answers
What format does a DVD player with a USB port play?Best solution by Yahoo! Answers

Just Added Q & A:

How many active mobile subscribers are there in China?Best solution by Quora
How to find the right vacation?Best solution by bookit.com
How To Make Your Own Primer?Best solution by thekrazycouponlady.com
How do you get the domain & range?Best solution by ChaCha
How do you open pop up blockers?Best solution by Yahoo! Answers

For every problem there is a solution! Proved by Solucija.

Got an issue and looking for advice?
Ask Solucija to search every corner of the Web for help.
Get workable solutions and helpful tips in a moment.

Just ask Solucija about an issue you face and immediately get a list of ready solutions, answers and tips from other Internet users. We always provide the most suitable and complete answer to your question at the top, along with a few good alternatives below.