Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Custom functions calculating time arguments Help Desperate | Excel Worksheet Functions | |||
Convert data into standard military time format | Excel Discussion (Misc queries) | |||
Excel should format time down to the hundredth/sec. | Excel Discussion (Misc queries) | |||
convert time imported as text to time format for calculations | Excel Worksheet Functions | |||
convert number to time format? | Excel Discussion (Misc queries) |