Time Comparisons

  • Thread starter Thread starter Shiraz Mistry
  • Start date Start date
S

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.
 
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.
 
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.
Click to expand...

Any help? Its been a few days now. :)
 
Back
Top