Hi All
Office excel 2003
got a times worked sheet but if text entered in a cell #Value error appears & destroys formular can I add to formular to ignore text in cells & only count time please find attached
sheet starts monday to sunday start & finish times with 1/2 hour deducted for lunch but need to fill in when someone on sick course or holday these are in a drop down list
Many thanks
Bookmarks