Time Zone Conversion

[Krix]

I have this Spreadsheet that has different country, Is it possible that it will auto convert the time into PHT Time (GMT +8) which is in Column A.

For example:
Its 3PM (Cell G1) in Bhutan. I want it to be converted in GMT +8
So therefore the time for GMT+8 will be 5PM and will be shown in Cell A1.

Also there will be an automated identifier in Column B that will identify if that time is for morning shift or night shift.
The morning shift is 12PM til 8PM
While the night shift is 8PM til 11AM.

Please help me thanks!

[Saarang84]

Hi Krix,

Check if zbor's post in the this thread might help you. Converting GMT time

In addition to the above link, check these links :
Tushar Mehta's link : Time Zone Conversion Examples
Cpearson VBA Approach : Time Zones And Daylight Savings Time

[FDibbins]

Test post, OP says they cannot post here

[Krix]

@Saarang84: Hi! Thanks for the inputs but I already saw those post and I think it won't help me on what I want to happen.

@FDibbins: I don't seem to understand you, did I post on the wrong forum corner?


Thanks!

[FDibbins]

Krix, no you did not do anything wrong, I was just testing to make sure there was nothing wrong with the thread, somebody (I think it was you?) said they could not post here, so I was just testing