View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
joel joel is offline
external usenet poster
 
Posts: 9,101
Default time diff across DST without VBA?

If you are subtracting two times then simply format the column with the
difference to any time/Date format as you like.

There are also time/date formats under custom. Excel will normally truncate
hours to 24 when the times are larger than a day. You can use [h]:mm:ss to
get hours greater than 24.

"George" wrote:

Can I (easily) get a simple difference between two time-format cells to
include the additional/missing hour across the DST change?

(Apologies if this is really old. I did google it.)

Thanks,
George