To add a number of years, months and/or days, use the DATE function. Note: the DATE function accepts three arguments: year, month and day. Excel knows that 6 + 2 = 8 = August has 31 days and rolls over to the next month (23 August + 9 days = 1 September).
Letâs multiply the percentage of cells in each stage by one-thousand, four-hundred and forty minutes to calculate how long the cell spends in each stage. We find that in a 24-hour period, the cells we observed spend 1000.2 minutes in interphase, 180 minutes in prophase, 128.2 minutes in metaphase, 77.8 minutes in anaphase, and 51.8 minutes in telophase.
Now weâll divide the total number of cells in each stage by the total number of cells counted, and multiply by 100 to get the percentage of cells in each stage. We get 69.6 % cells in interphase, 12.5% in prophase, 8.9% in metaphase, 5.4% in anaphase, and 3.6% in telophase. It takes about 24 hours, or one-thousand, four-hundred and forty minutes, for an onion root-tip cell to complete the cell cycle.