Help with World Clock

[yus786]

Hey, i'm having problems with the attached.

I have been asked to create a sheet in excel which looks at the world clock. So for instance if i enter 14.00 and select say India - it will give me the time in India

For the GMT+ it works OK, but for those with -GMT like USA etc, all i get is ####### sign.

Could someone please have a look at it and let me know where i've gone wrong?

Ideally i would like the current pc date to determine whether its BST or not but hey...

Thanks