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

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

Instead of:
2.11
enter:
2 11/16


--
Gary''s Student - gsnu200766


"DLM" wrote:

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

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,(FIN D(".",A2,1))))/16

in A3 will yield 6.5.

--
Ken Hudson


"DLM" wrote:

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

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


Replace @mailinator.com with @tiscali.co.uk


"DLM" wrote in message
...
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

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.

--
Stan Brown, Oak Road Systems, Tompkins County, New York, USA
http://OakRoadSystems.com/
"If there's one thing I know, it's men. I ought to: it's
been my life work." -- Marie Dressler, in /Dinner at Eight/