convert time from one zone to other zone in excel
hi,
just i need to convert time format from one zone to another zone E.g : EST into IST format. |
convert time from one zone to other zone in excel
=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. -- David Biddulph "ram" wrote in message ... hi, just i need to convert time format from one zone to another zone E.g : EST into IST format. |
All times are GMT +1. The time now is 04:54 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com