D
DonaldM210
Using MSN Stock Quotes, How do you convert Eastern Daylight Time to Central
Daylight time?
Daylight time?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
R
raypayette
You subtract one hour!
D
DonaldM210
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?????
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?????
R
raypayette
Which function?
D
DonaldM210
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.
**********************
:
=MSNStockQuote.Functions.MSNStockQuote($A4,"Time of Last Sale","US")
$A4 is the symbol of the stock.
**********************
:
D
daddylonglegs
If that function returns a time in time format perhaps
=MOD(MSNStockQuote.Functions.MSNStockQuote($A4,"Time of Las
Sale","US")+"23:00",1
=MOD(MSNStockQuote.Functions.MSNStockQuote($A4,"Time of Las
Sale","US")+"23:00",1