imperial weights

[silfox]

hello new to this Forum Had a look on the search for this How do I input imperial weights(Stones & Pounds) on an Excel chart? but could not find any info is there any body that can help me out please ive tried using the time but when you put it in a chart it shows up 1-60

thanks in advance

[TMS]

Maybe this will help ...

http://blog.contextures.com/archives...cker-in-stone/


Regards, TMS

[TMS]

Note that converting to time won't work as in time, you'd go from 08:59 to 09:00, not 08:13 to 09:00.

Regards, TMS

[ragulduy]

Make sure the axis numberformat is a time?

[ragulduy]

Barry Houdini's post here:
http://www.mrexcel.com/forum/excel-q...lculation.html
is useful for working with imperial weights:

You could also do this by using the DOLLARDE function from Analysis ToolPak. You'd have to input weights as 13.13 (with a decimal point) rather than 13:13 with a colon and then you'd use this formula in C4

=IF(B4="","",(DOLLARDE(B4,14)-DOLLARDE(B3,14))*14)

and this one in D4

=IF(B4="","",(DOLLARDE(B4,14)-DOLLARDE(B$3,14))*14)