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

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

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