Unfortunately, the following is only helpful if you don't mind putting
the hours and minutes in separate cells.

If this is ok then you could use these formulas to total:

HOURS
=INT((SUM(-[range of hour column]-)*60+SUM(-[range of minute
column]-))/60)


MINUTES
=SUM(-[range of hour column]-)*60+SUM(-[range of minute
column]-)-(-[cell where hours formula, shown above, is located]-*60)

Dan


--
Voodoodan
------------------------------------------------------------------------
Voodoodan's Profile: http://www.excelforum.com/member.php...nfo&userid=597
View this thread: http://www.excelforum.com/showthread...hreadid=395311