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

[OB1]

Hi Alex,

I have input the formulae you have provided, though the minutes ar
displaying correctly, the hours and days are not recognising. I jus
get the "#NAME?" in both.

I have checked every letter number against that what i have put into m
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 :

 

[anilsolipuram]

Alex formulae is perfect

I think function quotient is not available, run the Setup program t
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(D25),60)

total hours (c6) is =MOD(SUM(C2:C5)+int(SUM(D25),60),24)

total days (b6) is =SUM(B2:B5)+int(SUM(C2:C5),24

 

[Alex Delamain]

Do you have the analysis toolpack addin loaded? If not you should get
#value! error.

If you have a #Name? error it sounds more like a typo. Try copying an
pasting direct from the message boar