Please HELP: Adding Negative Time

[jasonj427]

Hi Guys,

Have a spreadsheet I am looking to set up to add the time accured or time owing for an employee. At times he works more than required and at times he works less than required, so I want to keep a record of his weekly surplus or deficit of hours. Problem I am having is when he is away for the week I can not get the right calculation in column J (in the attached spreadsheet). Seems to add onto the time as opposed on the actual hours worked.

Also is there an easy way in columns B-E that if the employee were to just type in "8" it would register it as being "8:00 AM?" as opposed to having to type "8:00?" Same goes with them typing "12.1" to register as "12:10 PM?"

Can some PLEASE help me.

Thanks,
Jason.