First of all I am a newbie at excel. So excuse me if this is a simple problem.
I am trying to use a worksheet to plan employees schedules. I would like to sum the hour totals of each colomn/row but, here is the catch, the cell data is a range of text and numbers. To top it off the numbers are not the value of what they are. For example D=12 hours, 7=8 hours, 23=8 hours, N=12 hours. Is there a way to asign values to text etc so that the colomns/rows add up?
Thanks
Brent
I am trying to use a worksheet to plan employees schedules. I would like to sum the hour totals of each colomn/row but, here is the catch, the cell data is a range of text and numbers. To top it off the numbers are not the value of what they are. For example D=12 hours, 7=8 hours, 23=8 hours, N=12 hours. Is there a way to asign values to text etc so that the colomns/rows add up?
Thanks
Brent