convert time from one zone to other zone in excel

R

ram

hi,
just i need to convert time format from one zone to another zone

E.g : EST into IST format.
 
D

David Biddulph

=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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Time Zone Conversion Table 1
Calculating the difference, in hours, between two date/time in two different time zon 2
Two time zones and nothing meshes 1
Using the IF function 1
Time Zone mismatch 0
Changing time zones 2
linking between spreadsheets 5
Time zone issues - getting the automatic acceptance to show up cle 1

Top