Timesheet

I will try this Thankyou for your prompt response.

And sorry to the mods for the double post.

I have created a form but I am struggling to get the formulas as you stated to work (because I don't understand them)

Times.xls

I have decided I will decimalise the times as I enter them as that will make for easyer sums as I am struggling with normal excel formulas without adding new TIME formulas.
Can you take a look at this and you will see what I am trying to do (is is spread over 2 sheets the second sheet will be printed to show just the hours worked for further payroll sums to be worked from by the accountant)

when working with time in excel if I type into a cell that is formatted to Time a figure eg. 600 I personally would assume that it would translate it to 6:00 AM but it doent does anyone know why?