I have been trying to figure this out for hours with no success. I've looked for templates and can't find what I need.

My company has created a timesheet in Excel, but it has no formulas for adding up the times. It's pretty basic, just a simple, clock in, clock out, subtract lunch type of thing. I've got the daily hours to add up, but when I try to get a subtotal, the results are not even close to right. I'm very confused. I don't know what I'm doing wrong.

Could anyone help with this?

Thanks,

Don