ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   how do i convert weight (stones+llbs) to llbs? (https://www.excelbanter.com/excel-worksheet-functions/64216-how-do-i-convert-weight-stones-llbs-llbs.html)

dilbert

how do i convert weight (stones+llbs) to llbs?
 
I wish to graph weight loss and record stones and llbs in total as llbs.

Is this achievable?

Bernard Liengme

how do i convert weight (stones+llbs) to llbs?
 
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
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"dilbert" wrote in message
...
I wish to graph weight loss and record stones and llbs in total as llbs.

Is this achievable?





All times are GMT +1. The time now is 04:04 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com