#### ehrynabbott

##### New Member

- Joined
- Mar 27, 2011

- Messages
- 2

column "A" employee name

column "B" as "time in"

column "C" as "time out"

then I have a hidden column - column "D" is calculated using the following "=TEXT(C7-B7,"h:mm")"

And that adds up the time worked for the day.

I have this set up Sunday through Saturday and at the end of the week, I have a formula totaling all my hidden columns using

"=SUM(D6+G6+J6+M6+P6+S6+V6)"

Which gives me total worked hours for the week.

My dilemma.... I need to calculate a 30 min lunch hour for the two managers and an hour lunch hour for those working OVER 6 hours in a day.

I have tried "=IF(cell>6,-.30)" but all I get as an answer is "########"

I've even tried to reformat the cells to a different format. Using [hh]:mm

or even "hh:mm"

Thank you for any advice anyone can give.