I have the formula below that T. Valko helped me with and it drags down the
columns fine but when I drag across it doesnt compute what I need. Perhaps I
need absolue reference symbol in front of the letter instead of the number in
each cell? Not sure really, I just know it makes me dizzy...Thanks for any
help!
-CRM

=ROUND((MAX(0,MIN(D$10*(D$10<""),B55)-MAX(C$10,A55))+MAX(0,MIN(F$10*(F$10<""),B55)-MAX(E$10,A55))+MAX(0,MIN(H$10*(H$10<""),B55)-MAX(G$10,A55))+MAX(0,MIN(J$10*(J$10<""),B55)-MAX(I$10,A55)))/60*1440,2)
--
-CRM