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.
Together, the G 1, S, and G 2 phases make up the period known as interphase. Cells typically spend far more time in interphase than they do in mitosis. Of the four phases, G 1 is most variable in terms of duration, although it is often the longest portion of the cell cycle (Figure 1).Figure 1: The eukaryotic cell cycle. Â© 2013 Nature Education All rights reserved.ells typically spend far more time in interphase than they do in mitosis. Of the four phases, G 1 is most variable in terms of duration, although it is often the longest portion of the cell cycle (Figure 1). Figure 1: The eukaryotic cell cycle. Â© 2013 Nature Education All rights reserved.