Thread: CREATE A FORMULA FOR HOURS WORKED THAT SUBTRACTS LUNCH
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bill Sharpe[_3_] Bill Sharpe[_3_] is offline
external usenet poster
  
Posts: 3
Default CREATE A FORMULA FOR HOURS WORKED THAT SUBTRACTS LUNCH
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