timezone calculation

Hello Everybody!

I am having a rather curious problem, and any ideas/help on this is Greatly Appreciated! I am writing a function called "DisplayTime" that calculates the time in any country, based on user input. for e.g. I want the user to be able to type in =DisplayTime("Albania") in a cell and the function will return the time in Albania. He/she can hence choose any country and have the function return the current local time in that country. For this purpose, I have a list of countries and their respective GMT offsets.

A scaled down version of this function looks like:

Please Login or Register  to view this content.

When I run this code I dont get the times im looking for! In fact i get some weird dates like "12/23/1899 10:51:18 AM".

Somebody help!

Regards,
J

Try with this code:

Please Login or Register  to view this content.

Use TimeSerial (hours, minutes, seconds)

Regards,
Antonio

Hello Carim, Antonio,

Thank you both so much for your replies! I'm sorry I couldnt reply sooner.

I tried out the TimeSerial Function and yes it worked!!
However when I print it out displaying the date and time, it shows up like "30/12/1899 07:56:53" for GMT and "30/12/1899 08:56:53" for Albania time.

My code now looks like:

Please Login or Register  to view this content.

I can do with just displaying the time, but displaying the date as well would be a bonus!

Once again thank you both for your replies!

Regards,
J