If you put the dollar symbol in front of the letter then it won't change as
you drag across. If you put a dollar in front of the number it won't change
as you drag down.
--
David Biddulph

"saltnsnails" wrote in message
...
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