The formulae by Mr Harkawat is wrong, he didnot correctly use minutes
and hours for calculating number of days.
modified formulae is
=(C5+INT((D5+(E5/60))/24))&" days "&MOD(D5,24)+MOD((INT(E5/60)),24)&"
Hrs "&MOD(E5,60)&" Mins"
--
anilsolipuram
------------------------------------------------------------------------
anilsolipuram's Profile:
http://www.excelforum.com/member.php...o&userid=16271
View this thread:
http://www.excelforum.com/showthread...hreadid=278319