How to convert Kgs to Stns, Pds & Ozs

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

FKBarnett - 15 Aug 2006 14:18 GMT

My wife is a dialysis patient at Freeman Hospital, Newcastle, UK and is more
used to the older units than Kgs. I have been trying to find a formular that
would convert Kgs to Stns, pounds and ounces with the result looking like,
61.5kg = 9stn 9lbs 10ozs

Reply to this Message

Bob Phillips - 15 Aug 2006 14:31 GMT

=ROUNDDOWN(kilos*0.15749,0) & " st " &
ROUNDDOWN((kilos* 35.27 - ROUNDDOWN(kilos * 0.15749,0)*224)/16,0) & " lb " &
ROUNDDOWN(kilos * 35.27 - ROUNDDOWN(kilos *0.15749,0)*224 - ROUNDDOWN((kilos
* 35.27 - ROUNDDOWN(kilos* 0.15749,0)*224)/16,0)*16,2) & " oz"

but do test it thoroughly, I would hate to be responsible for an incorrect
dosage.

Signature

HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

> My wife is a dialysis patient at Freeman Hospital, Newcastle, UK and is more
> used to the older units than Kgs. I have been trying to find a formular that
> would convert Kgs to Stns, pounds and ounces with the result looking like,
> 61.5kg = 9stn 9lbs 10ozs

Reply to this Message

Dave F - 15 Aug 2006 15:06 GMT

You can also go to google and etner, say "100 kilos to stones" and google's
calculation function will return it for you. For reference:
http://www.google.com/search?hl=en&q=100+kilos+to+stones

> =ROUNDDOWN(kilos*0.15749,0) & " st " &
> ROUNDDOWN((kilos* 35.27 - ROUNDDOWN(kilos * 0.15749,0)*224)/16,0) & " lb " &
[quoted text clipped - 10 lines]
> > would convert Kgs to Stns, pounds and ounces with the result looking like,
> > 61.5kg = 9stn 9lbs 10ozs

Reply to this Message