how to convert pounds and ounces into kilos

Rick Rothstein

MrExcel MVP

Joined

Apr 18, 2011

Messages

38,465

Office Version

1. 365

Platform

1. Windows

• Aug 4, 2015

• #2

tonywatsonhelp said:

I plan to input the pounds and ounces into cell H1 like this "12.13" for 12 pound 13 ounces

Click to expand...

Will the ounces always be less than 16? In other words, can someone input 20 ounces?

As a follow-up, how is 12 pounds 5 ounces inputted... 12.5 or 12.05 ?

 

Upvote 0

G

gaz_chops

Well-known Member

Joined

Apr 29, 2003

Messages

6,485

Platform

1. MacOS

• Aug 4, 2015

• #3

Try

=((INT(H1)*16)+MOD(H1,1))*0.02835

 

Upvote 0

Michael M

Well-known Member

Joined

Oct 27, 2005

Messages

21,835

Office Version

1. 365
2. 2019
3. 2013
4. 2007

Platform

1. Windows

• Aug 4, 2015

• #4

and if it's

12 stone 13 pound

Click to expand...

will there be any ounces, and as Rick has stated, how would 12 stone 13 pounds and 5 ounces be input into the cell ??

 

Upvote 0

diddi

Well-known Member

Joined

May 20, 2004

Messages

3,337

Office Version

1. 2010

Platform

1. Windows

• Aug 4, 2015

• #5

if it is pounds and ounces...
then if value is in D11

Code:

=(VALUE(LEFT(D11,FIND(".",D11,1)-1))+VALUE(RIGHT(D11,FIND(".",D11,1)-1))/16)*0.454

 

Last edited: Aug 4, 2015

Upvote 0

T

tonywatsonhelp

Well-known Member

Joined

Feb 24, 2014

Messages

3,194

Office Version

1. 365
2. 2019
3. 2016

Platform

1. Windows

• Aug 4, 2015

• #6

hi rick,
I just realised I was wrong and edited this as its stone and pounds I need,
Its really simple I have a excel weight tracker template that I downloaded but its in Kilograms, but we work in stones and pounds so I just want to be able to input the stone and pounds and have it convert to kilos.
I will be adding the data as its read off the scales so will always be 12 stone 10 for example.

thanks

Tony

 

Upvote 0

G

gaz_chops

Well-known Member

Joined

Apr 29, 2003

Messages

6,485

Platform

1. MacOS

• Aug 4, 2015

• #7

Oops that was for lb & oz

Try

=((INT(A1)*14)+MOD(A1,1)*100)/2.2

 

Upvote 0

Rick Rothstein

MrExcel MVP

Joined

Apr 18, 2011

Messages

38,465

Office Version

1. 365

Platform

1. Windows

• Aug 4, 2015

• #8

tonywatsonhelp said:

I will be adding the data as its read off the scales so will always be 12 stone 10 for example.

Click to expand...

What will be written in the cell for that (12 stone 10)... 12.1 or 12.10?

How would 12 stone 1 be written, 12.01?

 

Upvote 0

T

tonywatsonhelp

Well-known Member

Joined

Feb 24, 2014

Messages

3,194

Office Version

1. 365
2. 2019
3. 2016

Platform

1. Windows

• Aug 4, 2015

• #9

will be as I read it on my scales so

12.1
12.9
12.10

 

Upvote 0

G

gaz_chops

Well-known Member

Joined

Apr 29, 2003

Messages

6,485

Platform

1. MacOS

• Aug 4, 2015

• #10

Did you try my last formula?

 

Upvote 0