Is there any way to show time in a cell but only have it change when 5 minutes elapses. So for example, i have the time 12:00 in a cell, I would not want this time to change until the time is 12:05. I would prefer to do this without using vba if possible.
thanks all
thanks all