1 You really don't need to use INT since it is an extra step, you can use
MOD instead like in

=SUMPRODUCT(MOD(A1:A20,1))

make sure the cell with the formula is formatted as [hh]:mm or else it will
not display times over 24 hours



--
Regards,

Peo Sjoblom

(No private emails please)


"teastman" wrote in
message ...

Gary's student, your solution works fine. But if I add more and more
records to add... how do I do a totalled range. For example adding all
columns from a1 to a20.


--
teastman
------------------------------------------------------------------------
teastman's Profile:
http://www.excelforum.com/member.php...o&userid=30030
View this thread: http://www.excelforum.com/showthread...hreadid=497168