Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Time Zone Conversion Table
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 |
#2
|
|||
|
|||
Quote:
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Is there a time zone conversion function in Excel? | Excel Worksheet Functions | |||
convert time from one zone to other zone in excel | Excel Worksheet Functions | |||
Time Zone.. | Excel Discussion (Misc queries) | |||
Time zone using VBA | Excel Programming | |||
Time zone using VBA | Excel Programming |