Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Greg
 
Posts: n/a
Default Is there a macro to convert times between 2 places dep. on date?

I'm trying to convert times every month between my location and up to 50
locations. Depending on the date and which city/country/daylight savings
time, it is inconsistent. I've used the world time and date clock website
which is helpful, but was wondering if anyone knew of a macro or program that
would automatically calculate the time based on the date entered. I
currently maintain a schedule in excel, but was wondering if there is some
other tool that would be able to handle this.
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ron Rosenfeld
 
Posts: n/a
Default Is there a macro to convert times between 2 places dep. on date?

On Tue, 15 Nov 2005 13:27:12 -0800, "Greg"
wrote:

I'm trying to convert times every month between my location and up to 50
locations. Depending on the date and which city/country/daylight savings
time, it is inconsistent. I've used the world time and date clock website
which is helpful, but was wondering if anyone knew of a macro or program that
would automatically calculate the time based on the date entered. I
currently maintain a schedule in excel, but was wondering if there is some
other tool that would be able to handle this.


If you have the time zones for the different locations in a table, it should
not be a problem to convert times in Excel. It's just a matter of adding
(subtracting) the appropriate number of hours; probably using a table and
VLOOKUP.


--ron
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
Convert Text to DATE Dimmer Excel Discussion (Misc queries) 8 January 22nd 09 02:15 PM
How to convert date to text galsaba Excel Discussion (Misc queries) 2 May 22nd 05 08:31 PM
How do I convert Date serial number to date rdunne Excel Worksheet Functions 1 April 12th 05 03:04 PM
Convert 20050118 to a working date field Jessica Excel Worksheet Functions 7 February 23rd 05 11:07 PM
Date and Time Macro m.j.anderson Excel Discussion (Misc queries) 1 December 1st 04 01:35 AM


All times are GMT +1. The time now is 07:03 PM.

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"