I have a spreadsheet full of UTC codes and I want to convernt them to a
standard date time format
I have a spreadsheet full of UTC codes and I want to convernt them to a
standard date 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" <[email protected]> wrote in message
news:[email protected]...
> I have a spreadsheet full of UTC codes and I want to convernt them to a
> standard date 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" <[email protected]> wrote in message
> news:[email protected]...
> > I have a spreadsheet full of UTC codes and I want to convernt them to a
> > standard date time format
>
>
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks