Converting Eastern time to Central time

[DonaldM210]

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

[raypayette]

You subtract one hour!

[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?????

"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
>
>

[raypayette]

Which function?

[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.
**********************
"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
>
>

[daddylonglegs]

If that function returns a time in time format perhaps

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