Random Time Between Fixed Lower And Upper Limits

**testingcode** · 07-19-2013, 11:09 PM

Are you wanting 6-9am in the Stretches column, 11am-2pm in the Running warmups column, ect..?

If so, then you can just use the

Code:

=TIME(6,RANDBETWEEN(0,180),0)

in the correct column and adjust the bolded numbers to whatever time frame is needed for that column. The example formula above would be for the Streches column.

**papabill** · 07-20-2013, 11:08 PM

Originally Posted by testingcode

Code:

=TIME(6,RANDBETWEEN(0,180),0)

Can you explain something for me? I understand MOST of the formula, but not all. =TIME(6,RANDBETWEEN(0,180),0)

I understand the 6 (6 oclock) and the 180 (180 minutes-three hours past 6 = 9), but what about the 0 in (0,180)?

Thanks

**testingcode** · 07-22-2013, 04:28 PM

Originally Posted by papabill

Can you explain something for me? I understand MOST of the formula, but not all. =TIME(6,RANDBETWEEN(0,180),0)

I understand the 6 (6 oclock) and the 180 (180 minutes-three hours past 6 = 9), but what about the 0 in (0,180)?

Thanks

RANDBETWEEN(0,180) means that it picks a random number between 0 and 180. 0 is your lower bound and 180 is your upper. For example, a RANDBETWEEN(10,180) would never return a 1, 2, or 3, ect..