Below is an example of what I have in my cells, and I can use in and out times, but I would like to know if I can do it with this type of schedule, and have totals at the end, while treating the text as zeros. Any ideas? thank you for the help.
JULY 19 20 21 22 23 24 25
Sun Monday tues Wed Thurs Fri SAT HOURS
JEFF off off vac vac 700-300 off off off 8
NESSA 700-300 700-1900 1000-1900 700-1900 1000-1900 1000-1900 off 46
WILLY off 900-1800 900-1800 900-1800 900-1800 900-1800 off
MIA 730-230 off 630-630 off 630-630 630-630 off 36
MIKE off 600-230 600-230 600-230 600-230 600-230 off 40
PHILIP 800-200 830-500 off off off off 800-200 off off 20
REGGIE off 800-500 off 800-500 800-500 800-500 800-200 40
KENNY off 11-500 11-500 11-500 off 830-500 800-200 30
JOHN W. off float 4th 730-4 730-4 730-4 730-4 off 40
BILL F. off 700-330 700-330 700-330 off off 24