•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
How would I convert a table of descriptive text to a numeric formula?
I have the following dataset as an example. It lists names and absences - how can I convert it to record a total number of absences if 1 full day absence = 1, and a part day absence =0.5 to determine a total? Thank you
| Name | 2 full day absences, 2 part day absences |
|---|---|
| Name 2 | 0 full day absences, 3 part day absences |
| Name 3 | 2 full day absences, 0 part day absences |
[link] [comments]
Want to read more?
Check out the full article on the original site