"Rod C" wrote:

I want to create a spreadsheet to track weight loss/gain for a number of
people in our office. The gotcha is that we want to work in Stones and pounds
(1Stone=14Lb). I would like to be able to calculate differences between
cells displayed in Stones/Lbs

I have a work around, but its long winded....

First, enter the weight into feilds in text format, using ss-pp, ie 12-04
for twelve stone four pounds (I will assume this is in A1). Then use
LEFT(A1,2) and RIGHT(A1,2) in two cells to the right (B1 and C1) to split
these into two values in seperate cells.

In a D1, do =(B1*14)+C1 , to get the total in pounds. Copy these cells down
all of the rows you plan to use.

Use column E to get the total pounds gained or lost compared to last week.
In the second week, you would enter this into E2: =D2-D1

To convert this pounds back into stone and pounds, put this in F2:
=ROUNDDOWN(E2/14,0) to get the stones gained or lost. In G2: =E2-(F2*14) to
get the pounds gained or lost.

Hope this makes sense...

Tim