Prev Previous Post   Next Post Next
  #1   Report Post  
Junior Member
 
Posts: 8
Default Random time?

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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
time delay refresh on random number Bertrand[_2_] Excel Worksheet Functions 2 January 27th 10 01:00 AM
Entering a random date and time in a cell Dermot Excel Discussion (Misc queries) 1 August 19th 06 03:35 PM
Excel Charts - Time line for random points on X axis Anjalika Silva Excel Worksheet Functions 2 January 10th 06 09:22 PM
Non-random numbers generated by excel's data analysis random gener Harlan Grove Excel Discussion (Misc queries) 2 September 13th 05 04:06 PM
Various Random Codes not working from time to time Todd Huttenstine Excel Programming 0 May 21st 04 01:50 PM


All times are GMT +1. The time now is 11:17 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"