Hi All
Worked out how to total times worked for the week but need to deduct lunch breaks 30 minutes each day but ignore blanks (not to deduct the 30 minutes when blank) & ignore cells with text in
Please see sheet attached
text in drop down menus
When text entered total cell shows "Value#"
at the moment I get in totals cell 59.30 When I m after should be 56:00
Bookmarks