It is split into two parts one is 10 days in hometown and 5 days in the USA. If you want to calculate a percentage of a number in Excel simply multiply the percentage value by the number that you want. Calculate a percent distribution you can use a formula that simply divides an amount by the total.
Just right-click on a cell that contains a decimal or a row or column full of such cells and select Format Cells.
If you are using Excel for the web click Home Number Format Percentage. Start by selecting the first cell in the Percentage of Change column. Use the PERCENTRANKEXC function to determine the percentage rank exclusive of the first and last values in the array. Number 1 is subtracted by the percentage discount.