I am not sure if what i am asking is possible, i have looked around and have not found anything similar.
I want a random time to be generated between 0 and 15 minutes, and for this to be added to time now, when this new time is reached i would like the contents of a cell to be displayed.

So something like

new time = NOW() + RANDBETWEEN(0,15) ------ store value

when time = new time(stored value) then display cell contents


If you have seen my previous question you will understand i am fairly new to Excel, so any explanation and help appreciated.


regards

slipper