Originally Posted by naven_sg

Hello All,

Need a Help in Conversion of Time Zone.

I have a table in MST Time Zone, with 30 minutes interval. The data shows how many FTE working during that time. I want to Convert this to GMT Time Zone. I am attaching a Spreadsheet with the data. This should be dynamic so that if i change the Time difference spreadsheet should update accordingly.

Let me give you an example on results.

Time Diffrence between MST and GMT is 7 hours.

Ex 1:
MST - Monday
4:00 AM - 3

in GMT table results should appear in

GMT - Monday
11:00 AM - 3


Ex 2:
MST - Monday
11:00 PM - 3

in GMT table results should appear in

GMT - Tuesday
5:00 AM - 3

Please observe the day has been changed.

Regards,
NG