Generating random time in excel 2010

Must A3 be bigger than A2? Must A2 be bigger than A3?

More detail, please.

@Czeslaw

That's not random, though, is it?

Assuming that you want truly continuous, uniformly distributed, random numbers (and times in Excel are just numbers with a time format), then use the RAND() function. Help file: https://support.microsoft.com/en-us/...0-021ea9f5be73 Note in particular the first remark in the Remarks section about generating random numbers between a and b. Something like =RAND()*(TIME(9,15,0)-TIME(9,0,0))+TIME(9,0,0). Is that what you want, or are you looking for something different?

For random hour and random minute:

=TIME(RANDBETWEEN(0,23), RANDBETWEEN(0,59), 0)

Change the limits (e.g. 0 to 59) as desired. Replace RANDBETWEEN as desired (e.g. 9 for hours).

Caveat: When you add 3/1440 down the column, it might be prudent to round to the minute, especially if you intend to match times and/or you intend to generate a very long list (e.g. 24 hours). For example, with your short list starting at 9:00 in A1 and =A1+3/1440 in A2, note that =MATCH(TIME(9,3,0),A2,0) returns #N/A, indicating that A2 is not an exact (binary) match.

To round to the minute, use the form =--TEXT(A1+3/1440, "[h]:m") .