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