Handling Pounds, Shillings and Pence

I've got some data that is in pounds, shillings and pence. There's 12 pence to a shilling and 20 shillings to a pound. Any suggestions for handling this?

​

Additionally, it may be the case that somewhere in the data it switches from 12p/1s to 10p/1s. How would I best approach this?

Posted Dec 6, 2018, 1:24 AM UTC

18
Loading comments…