time conversion

[horizon]

I need to convert and standardized 2 things: military time and than convert that time from India/New Dehli standard time to Eastern standard(NYC) time.

Thks

 

[Vasant Nanavati]

To convert military time in A1 to "standard" time:

=TIMEVALUE(LEFT(A1,2)&":"&RIGHT(A1,2))

To convert Indian Standard Time in B1 to US Eastern Daylight Time:

=B1-(9.5/24)

--

Vasant

I need to convert and standardized 2 things: military time and than

convert that time from India/New Dehli standard time to Eastern
standard(NYC) time.

 

[horizon]

Not working when i attemtpt to convert India time to NY time. it gives me ############(negative time)