Adding weight measures

[DLM]

Can anyone help with adding weight measures? For example, how can you add
3.13 lbs and 2.11 lbs. If you sum, the answer will be 5.24 lbs versus the
correct answer of 6.8 lbs

 

[Gary''s Student]

Change how you enter data. Instead of:
3.13
enter:
3 13/16

Instead of:
2.11
enter:
2 11/16

 

[Ken Hudson]

Your question is a bit confusing. I assume that you mean 3 lbs. and 13 ozs.
plus 2 lbs. and 11 ozs.

The sum would be 6.5 pounds.

With 3.13 in A1 and 2.11 in A2 then

=((LEFT(A1,FIND(".",A1,1))*16)+RIGHT(A1,(FIND(".",A1,1)))+(LEFT(A2,FIND(".",A2,1))*16)+RIGHT(A2,(FIND(".",A2,1))))/16

in A3 will yield 6.5.

 

[Sandy Mann]

If you mean 6.08 instead of 6.8 lbs, with 3.13 in A1 and 2.11 in A2 try:

=INT(A1)+INT(A2)+INT(MOD(A1,1)*100/16+MOD(A2,1)*100/16)+(MOD((MOD(A1,1)*100/16+MOD(A2,1)*100/16),1)*16/100)

But I think that Gary"s Student's suggestion is a better way to do it.

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk

 

[Stan Brown]

Mon, 28 Jan 2008 10:57:01 -0800 from DLM

Can anyone help with adding weight measures? For example, how can you add
3.13 lbs and 2.11 lbs. If you sum, the answer will be 5.24 lbs versus the
correct answer of 6.8 lbs

The correct answer *is* 5.24 lbs. 3.13+2.11 is 5.24.