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