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
 
Top