Subtracting Break from Total Hours Worked

**martah26** · 05-21-2009, 04:31 PM

Hi,
This is probably a very simple problem that has me going around in circles.

I am attempting to set up a time roster, where I simply want to check:

If "end-time" minus "start-time" is greater than 4:00 (hrs), then deduct 00:30 (minutes) and place that result in another cell.

If it is not greater than 4:00 (hrs) then leave unchanged.

I have read thru countless examples on the Forum - but I think that such great learning is driving me mad. Although I do believe that I have the correct format [h].mm - but attempts with IF's have got me confused.

This is one of those "Looking down the tunnel towards the flickering light" moments.

Many thanks http://www.excelforum.com/images/smilies/confused.gif

**NBVC** · 05-21-2009, 04:37 PM

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.

**shg** · 05-21-2009, 04:37 PM

Welcome to the forum.

Please take a few minutes to read the forum rules, and then amend your thread title accordingly.

**GuruWannaB** · 05-21-2009, 05:01 PM

Take a look at this and see if it helps.
Hope it helps,

GWB

**martah26** · 05-21-2009, 05:08 PM

That's perfect - It will also help me to get a clearer look at what my overall end result will probably look like - I did have an overly-ambitious idea of what I wanted, but at this initial stage I think I'll stick to "baby-steps".

Thanks a heap GuruWannaBe & the Moderators.