CREATE A FORMULA FOR HOURS WORKED THAT SUBTRACTS LUNCH

[Mrs Boyd]

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.

 

[Teethless mama]

Modify your formula, put a minus sign instead of a plus sign for lunch hour.

 

[Bill Sharpe]

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

 

[Gord Dibben]

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