The math to determine a percentage is to divide the numerator the number on top of the fraction by the denominator the number on the bottom of the fraction then multiply the answer by 100. Select the cell containing the number of which you want to find 10. Percentage of Days spent in Home Town 10 15 100 6666.
Press Tab then in B18 enter this Excel percentage formula.
The kind of formula to use in Excel depends on the desired result. C6 C11. Enter the formula C2B2 in cell D2 and copy it down to as many rows as you need. Select the cell in which you entered 10.