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.
Assume that the number of cells in a phase is an indication of the time spent in that phase during mitosis. Time spent in a mitosis phase and in interphase can be calculated if the total time for mitosis is known. Onion cells require 12 hours (720 minutes) to complete a cell cycle (from interphase to interphase).The amount of time needed for a phase can be calculated using this formula:time for a phase = (number of cells in a phase)/(total number of cells counted)*720 minutes.nion cells require 12 hours (720 minutes) to complete a cell cycle (from interphase to interphase). The amount of time needed for a phase can be calculated using this formula: time for a phase = (number of cells in a phase)/(total number of cells counted)*720 minutes.