Converting Eastern time to Central time

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Using MSN Stock Quotes, How do you convert Eastern Daylight Time to Central
Daylight 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?????
 
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.
**********************
:
 
If that function returns a time in time format perhaps

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

FORMATTING/CONVERTING TO ZULU TIME 6
Drop down list & Time Zones. 2
Daylight saving time 1
Daylight Saving Time for 3 zones 1
Convert US Eastern Time to local .Net C# time? 1
Convert US Eastern Time to local .Net time? 3
Windows XP SP3 handles Daylight Savings Time end incorrectly? 16
Daylight saving time calculation 1

Back
Top