Time Zone Conversion Table
On Fri, 9 Nov 2012 13:35:32 +0000, naven_sg wrote:
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
+-------------------------------------------------------------------+
+-------------------------------------------------------------------+
There was no workbook attached.
Excel stores dates/times as days and fractions of a day since 1/1/1900 (or 1/1/1904 for certain versions or settings).
So for the conversion, and to make it dynamic, you merely use a formula in the GMT table to add the hours difference.
If the hours difference is an integer in A1; you would add to the MST table values A1/24 or TIME(24,0,0). This will automatically take care of "next day" issues.
|