Is it possible for a cell to reference itself in a formula? For example, Im trying to have a cell calculate a time of day based off of a specified amount of time (e.g. 20 minutes) more than the time in another cell. I then want to round up that time by using the ceiling function. The problem Im having is the ceiling function needs to refrence the time in a specified cell, which in htis case is the cell Im putting these functions in.
I know this can be done by creating 2 separate cells, one to make the first calculation and the second to round up, but I want to try and keep them in the same cell. Any one know if this is possible and if so how? TIA