Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Junior Member
 
Posts: 2
Post 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   Report Post  
Junior Member
 
Posts: 2
Default

Quote:
Originally Posted by naven_sg View Post
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
** Sorry forgot to attach File **
Attached Files
File Type: zip Time Converter Exercise.zip (11.2 KB, 34 views)
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1,045
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Is there a time zone conversion function in Excel? Scott Excel Worksheet Functions 1 August 23rd 08 06:25 PM
convert time from one zone to other zone in excel ram Excel Worksheet Functions 1 April 25th 07 01:24 PM
Time Zone.. Trevor M Excel Discussion (Misc queries) 1 April 10th 06 08:49 AM
Time zone using VBA ged Excel Programming 0 October 25th 04 05:29 PM
Time zone using VBA ged Excel Programming 1 October 20th 04 05:25 PM


All times are GMT +1. The time now is 01:45 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"