Check out my website: Hours affected by dates. It handles times spanning
midnight.
Please let me know if it suits?

Cheers

--
Rob van Gelder - http://www.vangelder.co.nz/


"leo" wrote in message
...

The shorter formula I got does work as well, except for column D where
0:00 start and 01:00 end are stored.

AND I figured this is still a bit too long (255 characters does not
"copy-sheet" and needs "copy cells")

Thx
LEO

+IF(+IF($AB12AT$9;0;MAXA(AT$8;$AB12))=0;+AT$9-MAXA(+IF($AB12AT$9;0;MAXA(AT$8;$AB12));IF($AC12<A T$8;0;MINA($AC12;AT$9)));AT$9-IF($AB12AT$9;0;MAXA(AT$8;$AB12)))-(AT$9-MAXA(+IF($AB12AT$9;0;MAXA(AT$8;$AB12));IF($AC12<A T$8;0;MINA($AC12;AT$9))))


--
leo