Is there a function or calculation that will convert UNIX time to norma time? Thanks, Crai
C cwalker123 Nov 3, 2004 #1 Is there a function or calculation that will convert UNIX time to norma time? Thanks, Crai
B Bernie Deitrick Nov 3, 2004 #2 Craig, =A1/86400+DATE(1970,1,1) where A1 has the UNIX date/time stamp. Format for date, time, or date/time. HTH, Bernie MS Excel MVP
Craig, =A1/86400+DATE(1970,1,1) where A1 has the UNIX date/time stamp. Format for date, time, or date/time. HTH, Bernie MS Excel MVP
