I have a column fur reach day of the month and rows of different members of staff.
For each day I place characters and numbers for every member, so as to track stats on time spent on tasks.
The convention is like this...
1a being one person 10 minutes. 2b two persons 15 minutes so on in increments of 5 (a is always 10, the minimum for task)
I can't get a formula to count up all the 1a's for example, or 2b's.
I can do it with just one entry per cell, that's easy but having multiple inputs in one cell is proving harder eg, 1a 2b 2c.
I need to have each entry counted for the whole spreadsheet, including multiple entries in a cell.
Anyone able to help?
For each day I place characters and numbers for every member, so as to track stats on time spent on tasks.
The convention is like this...
1a being one person 10 minutes. 2b two persons 15 minutes so on in increments of 5 (a is always 10, the minimum for task)
I can't get a formula to count up all the 1a's for example, or 2b's.
I can do it with just one entry per cell, that's easy but having multiple inputs in one cell is proving harder eg, 1a 2b 2c.
I need to have each entry counted for the whole spreadsheet, including multiple entries in a cell.
Anyone able to help?