So I have a list of workers, one name per row, and each column has a date in the header. Against each worker under each date is a start time and number of hours worked in the format 6_8 if they start at 6 and work 8 hours, 10_4 if they start at 10 and work 4 hours etc. The cell is blank if they did not work.
At the bottom of this table I'd like to be able to extract the total number of hours worked on a particular day. Is this possible?
I understand it would make more sense to split the cells, but is my above problem solvable without using vba?
_
characters in the cells?