Thread: Date Conversion
View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.misc
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
 
Posts: 8,651
Default Date Conversion

"UNIX time 1091750400 is 08/06/2004 12:00am GMT."
according to http://soft.zoneo.net/Unixtime/index.php

At least one on-line converter does default to the user's local time unless
specifically asked to return the number in GMT.
--
David Biddulph

"JE McGimpsey" wrote in message
...
In article ,
"Port Man" wrote:

No, I'm not making a correction for GMT. Am I supposed to?


I don't know - what are you trying to accomplish?

If so, how?


One way would be to add 3600 for every hour of difference between your
local time and GMT.

You may also have to adjust for daylight savings time, depending on what
country and state you're in. Note that the rules for starting and ending
DST changed this year.

When I put the converted unix time of 1091750400 into an online time
converter, it pulls up that date.


Sounds like the online converter is making an adjustment for time zone.
Are you in the same time zone as the online converter assumes?

What am I doing wrong?


Nothing, but you need to specify your requirements fully. XL only knows
about dates and times as floating point numbers, and displayed times
assume a local reference rather than absolute (GMT).