ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Converting Times (https://www.excelbanter.com/excel-programming/301290-converting-times.html)

ryan wells

Converting Times
 
Hello,

Could someone please tell me how to convert times from timezone A to
timezone B, ie. convert a time (time only, no date) in cell A1, and
display the new (adjusted) time in cell B.

I want to convert from Greece time to Australian time.

It would be best if this was an add-in rather than a something I have
to sit on another sheet, as I file is already quite unwieldly with
many worksheets.

Thanks you very much!
Regards, Ryan

Rob van Gelder[_4_]

Converting Times
 
See Tushar Mehta's page: http://www.tushar-mehta.com/excel/timezone.htm


--
Rob van Gelder - http://www.vangelder.co.nz/excel


"ryan wells" wrote in message
om...
Hello,

Could someone please tell me how to convert times from timezone A to
timezone B, ie. convert a time (time only, no date) in cell A1, and
display the new (adjusted) time in cell B.

I want to convert from Greece time to Australian time.

It would be best if this was an add-in rather than a something I have
to sit on another sheet, as I file is already quite unwieldly with
many worksheets.

Thanks you very much!
Regards, Ryan





All times are GMT +1. The time now is 08:34 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com