how do I convert utc to a readable time format?
 

I have a spreadsheet full of UTC codes and I want to convernt them to a
standard date time format

how do I convert utc to a readable time format?
 

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)

"Jon" wrote in message
...
I have a spreadsheet full of UTC codes and I want to convernt them to a
standard date time format

how do I convert utc to a readable time format?
 

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

"Bob Phillips" wrote:

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)

"Jon" wrote in message
...
I have a spreadsheet full of UTC codes and I want to convernt them to a
standard date time format