Thread: CREATE A FORMULA FOR HOURS WORKED THAT SUBTRACTS LUNCH
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gord Dibben Gord Dibben is offline
external usenet poster
  
Posts: 22,906
Default CREATE A FORMULA FOR HOURS WORKED THAT SUBTRACTS LUNCH
Mrs. Boyd

See Chip Pearson's site for creating a timesheet with regular and OT hours
including lunch breaks.

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


Gord Dibben MS Excel MVP


On Tue, 16 Feb 2010 11:07:35 -0800, Bill Sharpe
wrote:

On 2/15/2010 8:06 AM, Mrs Boyd wrote:
I have found a template for a time sheet with everything I want except for
the fact that it adds the hour taken for lunch. I need it to subtract the
hour taken for lunch since it is not a paid lunch.

It might help if you'd show us what the formula (or formulas) looks
like. In any event you want to reduce the result by one hour.

Bill

Reply With QuoteReply With Quote