Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Help! I am stuck calculating Days, Hours, Mins please help
Hi Alex, I have input the formulae you have provided, though the minutes are displaying correctly, the hours and days are not recognising. I just get the "#NAME?" in both. I have checked every letter number against that what i have put into my sheet and i confirm it is exactly matching yours. Is there something i am missing? Best Regards OB1 Thankyou for replying to my post, duly appreciated :) -- OB1 ------------------------------------------------------------------------ OB1's Profile: http://www.excelforum.com/member.php...nfo&userid=461 View this thread: http://www.excelforum.com/showthread...hreadid=278319 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
Do you have the analysis toolpack addin loaded? If not you should get a #value! error. If you have a #Name? error it sounds more like a typo. Try copying and pasting direct from the message board -- Alex Delamain ------------------------------------------------------------------------ Alex Delamain's Profile: http://www.excelforum.com/member.php...o&userid=11273 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 |