Hi,

You might try something like this

=24*IF(TRUNC(A5,0)DATE(YEAR(A5),10,31),1/24+A5-A6,A5-A6)

Your adjustment will depend which time is in DST and which not.

--
Thanks,
Shane Devenshire


"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