Hi please help! I have spent most of today searching on the net and trying to fix this time sheet.

My finance lady needs to SEE the timesheet in 24 hour time.
I need the total time, minus the lunch break calculated, and the answer shown as a number (ie 10 and 30 minutes would look like 10.5, 10 hours and 45 minutes would show as 10.75).

Take a look at this screen shot:
timesheet pic.PNG

I've attached the sheet and you can see it here:

https://drive.google.com/open?id=0Bz...0VNeXRLN1pDb2c

Is there something I am doing wrong here?

Kind regards