It's actually subtraction, not addition.  I misspoke.  It's the same
calulation to determine the difference between integers, where one or
both might be negative. start - end = delta.  if you start at +1 and
end at -5, 1 - -5 = 6.  If you start at -9 and end at -4, -9 - -4 =
-5.

cheers,
barneyb

On 8/30/05, Jim Davis <[EMAIL PROTECTED]> wrote:
> > -----Original Message-----
> > From: Paul Hastings [mailto:[EMAIL PROTECTED]
> > Sent: Tuesday, August 30, 2005 3:20 PM
> > To: CF-Talk
> > Subject: Re: Timezone conversion
> >
> > > That's what I assumed... but I thought there must be some clever math to
> > do
> > > it without the interim conversion...
> >
> > add up the offsets first but pretty much the same thing.
> 
> I'm a bear of very little brain today but I still don't see this...
> 
> If the original zone is +1:00 and my zone is -4.00 adding them up gives me
> -3:00 which isn't right...
> 
> If I ignore the sign it works out to +5:00 (which is "correct" in that it's
> the offset needed to convert the source zone to the target zone).
> 
> But then if the original zone is -4:00 and the target zone is -5 I get
> either 9:00 or -9:00.
> 
> I'm just not seeing how adding up the offsets does it...
> 
> I know this is something that should be immediately obvious... but I'm just
> not having that light-bulb moment here.
> 
> I think I'll just do the interim conversion for now... but it still seems
> like there must be a simple formula for this.
> 
> > > Ah well... that'll work.  It's just not very elegant.
> >
> > it's not a problem that requires anything very elegant. it's run of the
> > mill. managing the tz is the real issue. ask isaac ;-)
> 
> Yeah... I'm just fried today.  Only a few hours of sleep for the past few
> nights.  ;^)
> 
> Jim Davis
> 

-- 
Barney Boisvert
[EMAIL PROTECTED]
360.319.6145
http://www.barneyb.com/

Got Gmail? I have 100 invites.

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:216871
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Reply via email to