Join Adsterra Banner By Dibhu

How to convert Timestamp to Date format

0
(0)

Guys, In our day today work with reports and excel many a times we get time as in this format:

Entry Time
1478001362
1478001306
1478001249
1478001147

If you are not having a separate column for Date explicitly you would need to decipher this timestamp value to Date format. You could use any of the following methods to convert this numeric value to date format::

A.) Now if you want to convert this data into a proper Date format you could use following formula in your excel sheet:

=(((COLUMN_ID_HERE/60)/60)/24)+DATE(1970,1,1)

For example if you put value 1478001362 in place of COLUMN_ID_HERE it will first give you a value like 42675.49725 (because it is in general format ), which is then converted into date format in excel then it will give you Date output as 01-11-2016.

B.)You could also use the formula : =A1 / 86400 + 25569

C.) FOR LIBRE OFFICE you should use the following formula:

=DATE(1970,1,1)+((((Column_id_here/60)/60)/24)

In case you are getting Error 509 in Libre office you may try and replace , by ; in the DATE() function

Facebook Comments Box

How useful was this post?

Click on a star to rate it!

We are sorry that this post was not useful for you!

Let us improve this post!

Tell us how we can improve this post?

Dibhu.com is committed for quality content on Hinduism and Divya Bhumi Bharat. If you like our efforts please continue visiting and supporting us more often.😀
Tip us if you find our content helpful,


Companies, individuals, and direct publishers can place their ads here at reasonable rates for months, quarters, or years.contact-bizpalventures@gmail.com


Happy to See you here!😀

Leave a Reply

Your email address will not be published. Required fields are marked *

धर्मो रक्षति रक्षितः