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.
A typical human cell might take about 24 hours to divide, but fast-cycling mammalian cells, like the ones that line the intestine, can complete a cycle every 9-10 hours when they're grown in culture1,2^{1,2}â1,2ââstart superscript, 1, comma, 2, end superscript.