how do i convert weight (stones+llbs) to llbs?

D

dilbert

I wish to graph weight loss and record stones and llbs in total as llbs.

Is this achievable?
 
B

Bernard Liengme

You could:
a) enter stones in one column (say A1) and pounds in the ext (B1) and use
=A1*14+B1 to compute pounds
or
b) format the range of cells to be used with Custom format # ??/14 and enter
scale reading in form 10 5/14 (wishful thinking?) and plot this data.

best wishes
 
Top