Try this for size:

If your data is in a1:d5 (row 1 headings, column a is skills)

total for minutes (d6) is =MOD(SUM(D2:D5),60)

total hours (c6) is =MOD(SUM(C2:C5)+QUOTIENT(SUM(D2:D5),60),24)

total days (b6) is =SUM(B2:B5)+QUOTIENT(SUM(C2:C5),24)


--
Alex Delamain
------------------------------------------------------------------------
Alex Delamain's Profile: http://www.excelforum.com/member.php...o&userid=11273
View this thread: http://www.excelforum.com/showthread...hreadid=278319