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