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

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

Post by kielh » Thu, 30 Sep 2004 20:27:30


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
 
 
 

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

Post by Arvi Laane » Thu, 30 Sep 2004 20:42:58

Hi

=109620072/(24*60*60)
and format in some time format as you need


--
Arvi Laanemets
(When sending e-mail, use address arvil<At>tarkon.ee)

 
 
 

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

Post by Bernie Dei » Thu, 30 Sep 2004 22:22:54

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