I have a spreadsheet full of UTC codes and I want to convernt them to a standard date time format
J Jon Jun 8, 2006 #1 I have a spreadsheet full of UTC codes and I want to convernt them to a standard date time format
B Bob Phillips Jun 8, 2006 #2 Just add the hours offset, like =A1+TIME(6,0,0) for CST -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct)
Just add the hours offset, like =A1+TIME(6,0,0) for CST -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct)
J Jon Jun 8, 2006 #3 Hi Bob Thanks for that. I probably wasn't too clear on the requirement but the good news is that I've found a solution. So to convert a UTC format date time eg 1139184300 into something sensible (this format is number of seconds since 1/1/1970) I used... =DATE(1970,1,1+(A1/(60*60*24)))+TIME(0,0,MOD(A1,(60*60*24))) Cheers Jon
Hi Bob Thanks for that. I probably wasn't too clear on the requirement but the good news is that I've found a solution. So to convert a UTC format date time eg 1139184300 into something sensible (this format is number of seconds since 1/1/1970) I used... =DATE(1970,1,1+(A1/(60*60*24)))+TIME(0,0,MOD(A1,(60*60*24))) Cheers Jon
