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

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

--
HTH

Bob Phillips

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

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

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...ilos+to+stones

"Bob Phillips" wrote:

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

--
HTH

Bob Phillips

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

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