Formula help wanted

**LPlate** · 07-16-2009, 07:26 AM

Hi
Can anyone help me with a formula

I'm currently working on a work sheet
to calculate working hours / overtime etc.
All is working fine and I have set it so that I can enter start and finish times
and working hours are totalled.

To get the overtime hrs or undertime hrs I have used the
following formula In Cell K8(total overtime/undertime)
=G8-$E$23
which relates to Cell G8(Actual Hours Worked)
and Cell E23( Required Hours which are 07:12)

All works fine and when times are entered, total hours and
overtime/undertime hours are calculated in cell K8.

The only problem I have is that if no times are entered and
the actual hours worked are 00:00 then -07:12 appears in Cell K8
But I would like it to show 00:00 as there is no overtime or undertime.

Is there a formula I can add to Cell K8 to make it show zero if there are no actual hours worked ??

Hope Someone can Help

LPlate

**Palmetto** · 07-16-2009, 07:32 AM

Use the IF function to return zero

=if(G8=0,0,G8-$E$23)

**royUK** · 07-16-2009, 07:38 AM

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.

Also, post in the correct forum - this should be in the Excel Functions Forum