nigelandrewfoster
Well-known Member
- Joined
- May 27, 2009
- Messages
- 747
I have a simple rota spreadsheet which calculates hours worked per worker MONDAY to FRIDAY by inputting START and FINISHING times for each day. It works, until the user inputs "HOLIDAY" or other text into the table, which results in "#VALUE!" in the totals box. Is there any way I can get Excel to ignore text or treat it as zero without resorting to a macro?