function to convert 'nnnnnnnnnn' ---> 'dd.mm.yy hh:mm:ss'

K

kielhd

Hi NG,

I am looking for a function of MS EXCEL to convert the seconds from
01.01.1970 (e.g. 1096200072) into a more common date format like
dd.mm.yy hh:mm:ss.

TIA,
Henning
 
B

Bernie Deitrick

Henning,

=109620072/(24*60*60)+"1/1/1970"

or using a cell reference:

=A1/(24*60*60)+"1/1/1970"

Format the cell with the formula for date/time.

HTH,
Bernie
MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

convert dd:hh:mm:ss to seconds 5
convert to date format 3
Converting hh:mm:ss to seconds only 2
Date and Time (entering in the format of mm/dd/yyyy and hh:mm:ss ) 8
how do i convert standard time format into seconds? 4
hh:mm:ss keeps converting to a date 4
Average HH:MM:SS 1
How to average hh:mm:ss when hh is 00 4

Top