hi, just i need to convert time format from one zone to another zone E.g : EST into IST format.
R ram Apr 25, 2007 #1 hi, just i need to convert time format from one zone to another zone E.g : EST into IST format.
D David Biddulph Apr 25, 2007 #2 =A1+N/24, where N is the number of hourr difference in time zone. Hence to convert from UTC-5 to UTC+1, use =A1+6/24.
=A1+N/24, where N is the number of hourr difference in time zone. Hence to convert from UTC-5 to UTC+1, use =A1+6/24.