Hi,
I'm trying unsuccessfully, using various connotations of RANDBETWEEN, to enter a random time between say 20:18 and 20:30 (hh:mm) or 00:05 and 00:15 (If I use 20:18 I get a circular reference error.)
I can insert a random numbers, =RANDBETWEEN(1,5) without a problem but if I try =RANDBETWEEN(20.18,20.30) I get 00.00.
I've converted the times to numbers =RANDBETWEEN(0.8458333333,0.8541666667) and still get 00.00

Any help would be greatly appreciated.

Thanks,
Brian