Random Times

[CHML]

Hi. I'm looking for a formula that will generate a random time between 8:00 AM - 3:30 PM but can start only with 00,15,30 and 45.

Thank you

 

[DanteAmor]

Try thi:

Dante Amor
	A
1	random time
2	03:15 p. m.
3
Hoja1

Cell Formulas
Range	Formula
A2	A2	=TIMEVALUE(RANDBETWEEN(8,15)&":"&RANDBETWEEN(0,3)*15)

 

[CHML]

Exactly what I was looking for.

Thank you DanteAmor!

 

[Herakles]

Try thi:

Dante Amor
	A
1	random time
2	03:15 p. m.
3
Hoja1

Cell Formulas
Range	Formula
A2	A2	=TIMEVALUE(RANDBETWEEN(8,15)&":"&RANDBETWEEN(0,3)*15)

Should that not be :

=TIMEVALUE(RANDBETWEEN(8,15)&":"&RANDBETWEEN(0,2)*15)

as you don't want 15:45.

 

[bebo021999]

Or, another approach:

=(8+RANDBETWEEN(0,22)*0.25)/24

 

[Herakles]

Or, another approach:

=(8+RANDBETWEEN(0,22)*0.25)/24

Did you mean =(8+RANDBETWEEN(0,30)*0.25)/24

 

[bebo021999]

Did you mean =(8+RANDBETWEEN(0,30)*0.25)/24

Thank for correcting me. That what I intended to say.

 =(8+RANDBETWEEN(0,30)*0.25)/24

 

[Herakles]

Thank for correcting me. That what I intented to say.

 =(8+RANDBETWEEN(0,30)*0.25)/24

I thought so.

 

[CHML]

Thank you all.