Using Randbetween - tyring to create a random list of times, in 20second intervals

**jgeitner** · 03-14-2018, 06:57 AM

Hi,

So I'm trying to create a random set of start times for a run, which I'm okay to do, but I'm struggling to figure out how to make these go every 20 seconds.

I'm trying to have start times going from 09:30:00 through to 13:30:00, and the start times go in waves every 20 seconds, so 09:30:00, 09:30:20, 09:30:40,09:31:00 and so on...

Any ideas!

I had this formula in use =$A$7+RANDBETWEEN(0,INT(($B$7-$A$7-1/24)*24*60))/(24*60) - but that gives me no seconds to go on. I'd love to just add to this! Where cell A7 is 09:30:00 and cell B7 is 13:30:30.

Jonathan

**JohnTopley** · 03-14-2018, 07:10 AM

in B7

=A7+TIME(0,0,20)

copy across

EDIT: misread your post: why 13:30:30 in B7 ???

And your formula will give a circular reference

**Glenn Kennedy** · 03-14-2018, 07:16 AM

Try this:

=$A$7+RANDBETWEEN(0,($B$7-$A$7)*4320)*20/86400

But I'm not really sure what your expected results will look like....

Using Randbetween - tyring to create a random list of times, in 20second intervals

LinkBack

Thread Tools

Rate This Thread

Display

Using Randbetween - tyring to create a random list of times, in 20second intervals

Re: Using Randbetween - tyring to create a random list of times, in 20second intervals

Re: Using Randbetween - tyring to create a random list of times, in 20second intervals

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] RANDBETWEEN - maybe not so random

Assign random number (RANDBETWEEN) equal number of times

Generate Random Time Series using RANDBETWEEN, but NOT with RANDBETWEEN in Each Cell

Need help relating a list of random numbers to a list of names so that i can create a rota

Randbetween or Random Number (1,3)

How do I create a list of the most frequent numbers appearing in an exisiting random list?

Random numbers not using randbetween()

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions