| Home |
| Search |
| Today's Posts |
|
#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 |
| 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 | |||
Threaded Mode
