Help with designing timesheet for work

[pbraid]

I am trying to design a time sheet that auto calculates hours worked by putting in start and end time for each day of the week.
The formula I tried is -
=SUM(C4-B4)+(E4-D4)+(G4-F4)+(I4-H4)+(K4-J4)+(M4-L4)+(O4-N4)

This doesn't seem to be working properly and also it wont allow me to enter text in a box for say a "day off" or a "sick day" without the formula causing an error, is there a way round this?

I'm relatively new to excel and what I have learnt is been self taught, so I would be grateful for any help

[VBA Noob]

Here's some sample Timesheets which should help

http://www.cpearson.com/excel/overtime.htm

http://www.j-walk.com/ss/excel/files/timesht.htm

http://www.vertex42.com/ExcelLinks/cat/popular.html


VBA Noob

[pbraid]

Thanks for your quick reply.

However i'm a bit lost with the code.

I have attached a screenshot for ppl to look at. I want to add start time with end time for each day, I don't need lunch in or out and if possible it would be good to be able to input text without the formula erroring

thanks again.

[VBA Noob]

If you add the sheet someone will take a look

VBA Noob

[pbraid]

I have added the timesheet for some kind person to look at and see where i'm going wrong.

thanks.

[VBA Noob]

Hi,

Does this help

VBA Noob

[pbraid]

that seemed to work great however if i have inputed mon-sat and try to input sunday it doesn't add this also for some reason?

thanks once again for all your help

[pbraid]

it almost works however does not seem to calculate all days for some reason.

thanks again for your help.