G Guest Jun 2, 2004 #1 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
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 Jun 2, 2004 #2 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.
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.
G Guest Jun 8, 2004 #3 Not working when i attemtpt to convert India time to NY time. it gives me ############(negative time)
Not working when i attemtpt to convert India time to NY time. it gives me ############(negative time)
