Excel/VBA, getting the time and date for another country.?

Hi,

I am working on a project, it takes system time and date and shows it on a userform and a cell. I know that is very easy. But what I want is, a way where the cell on the worksheet can show what time and date it is in UK at this point. For your reference, I am in India and there is a +5:30 time difference I think between the GMT and IST.

Is there a way where, either the VBA code or a formula tells me what time and date it is now in the UK.

Many Thanks.