Here is the range of hours I am trying to convert to days.
- 0-2 days equal 5 hours
- 3-5 days equal 10 hours
- 6-10 days equal 15 hours
- 11-15 days equals 20 hours
In the picture, the highlighted column (Days) is where the conversion of the next column (Total Hours) will take place. Basically, the "Total Hours" column will convert into numbers in the "Days" column.