Adding weight measures

D

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
 
G

Gary''s Student

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

Instead of:
2.11
enter:
2 11/16
 
K

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.
 
S

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

[email protected]
Replace @mailinator.com with @tiscali.co.uk
 
S

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
Click to expand...

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