ok I am using excel to make schedules.

Lets say I have a schedule that has values 7a and 8a.

7a= 8 hour shift
8a = 12 hour shift
d = day off so 0

I want to be able to select the row and be able to turn that to numbers and add it.

Example
| S | M | T | W | T | F | S |
| D | 7a|7a | 7a| 7a| 8a|D|

so there are 4 "7a"'s = 4*8 = 32 and 1 "8a" = 12 *1 = 12 +32= 44 hours.

SO i want it to say 44. in that box.

Hope that helps.