Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculating Production/Man Days in Excel | Excel Discussion (Misc queries) | |||
Problems calculating total hours | Excel Discussion (Misc queries) | |||
Help! I am stuck calculating Days, Hours, Mins please help | Excel Worksheet Functions | |||
Help! I am stuck calculating Days, Hours, Mins please help | Excel Worksheet Functions |