time conversion

H

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
 
V

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




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

horizon

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