Explanation
The RAND function generates a decimal number between zero and 1.
For example, =RAND() will generate a number like 0.422245717.
RAND recalculates when a worksheet is opened or changed.
Related videos
How to generate random values
Random times at specific intervals
To generate random times in at specific intervals you can use the RAND function with the FLOOR function. In the example shown, the formula in B6 is: =FLOOR(RAND(),"0:15") which generates a random time at a 15-minute interval.
