Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
Tim Tim is offline
external usenet poster
 
Posts: 408
Default Time difference calculations, daylight savings time, Excel

I would appreciate someone explaining to me how to arrange for Excel to
arrive at correct time differences where two dates and times from a year long
list have been chosen, each of these time points being expressed using
different time zones. This will occur in any simple list of dates and times
covering a year where one chosen time point is during a period of Standard
Time and another to be compared is during Daylight Savings Time.
Regards,
--
Tim
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 7,247
Default Time difference calculations, daylight savings time, Excel

Tim,

See http://www.cpearson.com/excel/LocalAndGMTTimes.htm and
http://www.cpearson.com/excel/datedif.htm .

Download the files from the LocalAndGMTimes page.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
(email address is on the web site)

"Tim" wrote in message
...
I would appreciate someone explaining to me how to arrange for Excel to
arrive at correct time differences where two dates and times from a year
long
list have been chosen, each of these time points being expressed using
different time zones. This will occur in any simple list of dates and
times
covering a year where one chosen time point is during a period of Standard
Time and another to be compared is during Daylight Savings Time.
Regards,
--
Tim



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
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? Richard Excel Discussion (Misc queries) 2 May 13th 23 11:46 AM
Averaging Time Difference vldavis809 Excel Discussion (Misc queries) 1 July 8th 06 09:42 AM
Excel should format time down to the hundredth/sec. John Krick Excel Discussion (Misc queries) 3 November 28th 05 10:23 PM
How to Join/concatenate a date field with a time field in Excel? Alan Excel Discussion (Misc queries) 4 August 9th 05 10:07 PM
Unix Time in Excel Craig Walker Excel Worksheet Functions 2 March 21st 05 07:29 PM


All times are GMT +1. The time now is 04:13 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"