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.
Collectively, the G and S periods are known as interphase. The timeframe for completion of the entire cell cycle (the gap, synthesis, mitosis, and cytokinesis phases) varies depending upon the organism.