excel - time conversion ( IST to EST )

I have a colum which has the following values.

I need to change the timing to EST. The values are given in IST.

Tue Mar 30 10:23:46 IST 2010
Tue Mar 30 10:39:26 IST 2010
Tue Mar 30 10:41:46 IST 2010
Tue Mar 30 10:43:06 IST 2010
Tue Mar 30 10:45:06 IST 2010

Open in new window

LVL 23
Kamaraj SubramanianApplication Support AnalystAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:
Hello itkamaraj,

are these true date/time values? Or is it text?

If date/time values, find out the difference in hours between IST and EST and then calculate like

X1 = difference between IST and EST, e.g. -4 hours

with your date time values in column A, put this in column B


cheers, teylyn

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Kamaraj SubramanianApplication Support AnalystAuthor Commented:
that is a string
Kamaraj SubramanianApplication Support AnalystAuthor Commented:
thanks, your solution works for this format
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Visual Basic Classic

From novice to tech pro — start learning today.