Coverting the time zone

**Gireeshm** · 09-18-2006, 06:31 AM

Hi

I have some data where the dates are in IST(Indian Standard timing) and I want to convert this to EST(Eastern Standard timing). Can anyone help me out in this?

**JR@SGC** · 09-18-2006, 06:36 AM

Hi

Have you tried when you right click on a cell and select format cells, then select date from the list under the number tab there is then an option to change location.

Hope it helps

**Gireeshm** · 09-18-2006, 06:47 AM

I am looking to change the time that is listed instead of changing the format of the time. When I change the it to EST the current time should be showing a difference of 12 hours bahind the indian timing.

Any idea?

**Chappo** · 09-18-2006, 07:48 AM

You'll want to use the below formula

=IF(TIMEVALUE("5:00:00")-TIMEVALUE("12:00:00")<-0.1,(TIMEVALUE("5:00:00")-TIMEVALUE("12:00:00")*-1),TIMEVALUE("5:00:00")-TIMEVALUE("12:00:00"))

If you input the indian time where the 5:00:00 is then it should work it out for you.

hope that helps

Chappo

**oldchippy** · 09-18-2006, 08:11 AM

Originally Posted by Gireeshm

I am looking to change the time that is listed instead of changing the format of the time. When I change the it to EST the current time should be showing a difference of 12 hours bahind the indian timing.

Any idea?

Hi Gireeshm,

How about this?

Put your date/time in A1, then in A2 put

=A1-0.5

The 0.5 is half a day or 12 hours

oldchippy