ExcelBanter - how can I put weights in stones and pounds into an excel spreadshe

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - how can I put weights in stones and pounds into an excel spreadshe (https://www.excelbanter.com/excel-discussion-misc-queries/43996-how-can-i-put-weights-stones-pounds-into-excel-spreadshe.html)

SteveM

how can I put weights in stones and pounds into an excel spreadshe

I want ot record and then plot weights over a period of time. Will excel "do"
stones/pounds??

Anthony Slater

Try this: -

=INT(CONVERT(A1,"kg","lbm")/14)&" Stone(s) and
"&ROUND(MOD(CONVERT(A1,"kg","lbm"),14),0)&" Pound(s)"

"SteveM" wrote:

I want ot record and then plot weights over a period of time. Will excel "do"
stones/pounds??

All times are GMT +1. The time now is 03:35 AM.