Calculate hours worked minus 30 min break if hours worked are greater than 4.5 hours

**nikkiw** · 02-11-2013, 01:58 PM

Please help! I am trying to create a formula that calculates hours worked, but deduct a 30 minute lunchbreak only if the employee worked a total of 4.5 hours or more in that day. See attached spreadsheet...

**Moo the Dog** · 02-11-2013, 02:15 PM

** DUPLICATE POST **

Please close this post, and refer to this post.

- Moo

**FDibbins** · 02-11-2013, 02:26 PM

Welcome to the Forum, unfortunately:

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

http://www.excelforum.com/excel-form...4-5-hours.html

Thread Closed.

Calculate hours worked minus 30 min break if hours worked are greater than 4.5 hours

LinkBack

Thread Tools

Display

Calculate hours worked minus 30 min break if hours worked are greater than 4.5 hours

Re: Calculate hours worked minus 30 min break if hours worked are greater than 4.5 hours

Re: Calculate hours worked minus 30 min break if hours worked are greater than 4.5 hours

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions