Alex formulae is perfect

I think function quotient is not available, run the Setup program to
install the Analysis ToolPak. After you install the Analysis ToolPak,
you must enable it by using the Add-Ins command on the Tools menu.

or can use int command instead of quotient.



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

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

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


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