Help! I am stuck calculating Days, Hours, Mins please help
 

Didn't have Toolpak installed on my system, and there are friends of
mine that haven't got it either so i have used the formulae provided by
Mr Harkawat and works.

I'd like to thank all of you for helping me.

OB1


--
OB1
------------------------------------------------------------------------
OB1's Profile: http://www.excelforum.com/member.php...nfo&userid=461
View this thread: http://www.excelforum.com/showthread...hreadid=278319

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

anilsolipuram
Using your formula for 0 days 5000 hrs and 61450 mins i get 251 days 24 Hrs
10 Mins instead of 251 Days 0 Hrs 10 Mins
N Harkawat


"anilsolipuram" wrote in
message ...

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