Your problem statement is somewhat ambiguous.

Do your *checks* start at 6:00 am (i.e, 6:00 am every day), or should
the first check start between 6:00 am and, say, 6:55 am?

If no checks can happen between 10:00 am and 10:30 am, are you still
required to meet the 55 minute maximum? If so, you'll probably need an
iterative process and checks will be clustered just before 10:00 and
just after 10:30.


If you have to have one check between 6:00 and 6:55, and you can just
skip any checks falling between 10:00 and 10:30, you can use something
like this:

A1: =TIME(6, RAND()*55, 0)
A2: =A1 + TIME(0, 15+RAND()*40, 0)

and copy down through A49, discarding anything after 6:00 pm or between
10:00 and 10:30.

In article ,
"Tiffany" wrote:

Ok. I guess the government had to go and make this even more difficult for
me.

I need to figure out how to get random times for check during one day using
an Excel spreadsheet.

They start at 6:00 a.m. up until about 6:00 p.m. They have to be no more
than 55 minutes apart, but less than 15 min apart. They cannot be between
10:00 am and 10:30 am.

I received a response to my last question which was between 6 and 6pm, no
more than 55 min apart and not between 10 and 10:30 am. I set it up. It works
wonders. But, now I'm told they have to be at least 15 min apart. I tried to
adjust the formula accordingly, but I just can't figure it out.

Can anyone help me please???