Time report with #VALUE in Overtime columns, G and H don't clear out.

[kotoma]

Hi,
I have some problems with this worksheet, I wander if any kind can help?

How can be I get error #VALUE! If not working time are imputing in columns D,E;F?
Also I would remove the figures in colunms T. Timmar and N. Timmer (in Yellow) if I do Cad Work, otherwise I would get double hours.

Included the file also.

thanks in advance.
Kotoma

[royUK]

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

[kotoma]

Sorry! I agree with you. I was disapointed that the fomula didn't work for me.

I will do that and hope I learn more from it.

Reg.
Kotoma