Time Comparisons

[Shiraz Mistry]

Hi all,

is there a way to either set up a formula or macro that can easy work
out time comparisons for say, Melbourne, Australia and Toronto, Canada
within Excel?

I would prefer that you show me the steps involved and not simply how
you got the answer, as I would like to learn and train this to others.

Many thanks for your time,

Shiraz.

 

[Guest]

Assuming you dont want to use a web query to get the datas from some kind of table in the internet, you only have the time of your system, so you would have to build a variable with all time diferences (ie : melbourne : +3 hours...from your system) and then you can setup a function to return the time you want to.

 

[Shiraz Mistry]

Hi all,

is there a way to either set up a formula or macro that can easy work
out time comparisons for say, Melbourne, Australia and Toronto, Canada
within Excel?

I would prefer that you show me the steps involved and not simply how
you got the answer, as I would like to learn and train this to others.

Many thanks for your time,

Shiraz.

Any help? Its been a few days now.