Converting Eastern time to Central time
 

Using MSN Stock Quotes, How do you convert Eastern Daylight Time to Central
Daylight time?

Converting Eastern time to Central time
 

You subtract one hour!


--
raypayette


------------------------------------------------------------------------
raypayette's Profile: http://www.excelforum.com/member.php...o&userid=29569
View this thread: http://www.excelforum.com/showthread...hreadid=570898

Converting Eastern time to Central time
 

I'm trying to subtract the "one hour" as part of the function. I'm not sure
how to accomplish this. I can use additional columns to get the correct
answer, but, there must be a way to subtract or add within the fuction
itself. Any ideas?????

"raypayette" wrote:


You subtract one hour!


--
raypayette


------------------------------------------------------------------------
raypayette's Profile: http://www.excelforum.com/member.php...o&userid=29569
View this thread: http://www.excelforum.com/showthread...hreadid=570898

Converting Eastern time to Central time
 

Which function?


--
raypayette


------------------------------------------------------------------------
raypayette's Profile: http://www.excelforum.com/member.php...o&userid=29569
View this thread: http://www.excelforum.com/showthread...hreadid=570898

Converting Eastern time to Central time
 

Its an add-in function to track stock quotes:
=MSNStockQuote.Functions.MSNStockQuote($A4,"Time of Last Sale","US")
$A4 is the symbol of the stock.
**********************
"raypayette" wrote:



Which function?


--
raypayette


------------------------------------------------------------------------
raypayette's Profile: http://www.excelforum.com/member.php...o&userid=29569
View this thread: http://www.excelforum.com/showthread...hreadid=570898

Converting Eastern time to Central time
 

If that function returns a time in time format perhaps

=MOD(MSNStockQuote.Functions.MSNStockQuote($A4,"Ti me of Last
Sale","US")+"23:00",1)


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=570898