calculate 'wage' from number of hours worked between x and y hours

Hi,

I making a spreadsheet to use as a diary planner for part time staff at my current place of work, and i have just been asked to add the wages they earn each shift but really struggling with getting it to calculate when there shift ends on the half hour.. ..

In the example below, you can see what i mean. The shift which finished with a whole hour, calculates fine, the Shift which finishes with half an hour in it calculates incorrectly

Screen Shot 2014-12-18 at 23.39.22.png

How can i get the Wages column(E2 for example) to calculate the wages correctly as it should be £17.50.

For reference the formula i use for calculating E2 is as follows - =IF(D2="Y",(C2-B2)*A2,"")

wages.xls

try having a ghost column which is gonna calculate the hour difference + converting to decimal ( you can narrow these down very small then you don't even see after you type the formula then drag them down )

move your columns to the right from so d,e is empty ( d-->f+ e-->g)

in d2 =c2-b2
in e2 =hour(d2)+minute(d2)/60 make sure this cells are time formatted
in g2 =if(e2="y" ,e2*a2)