Random time

[Guest]

I would like to generate a random time for any given date. Say column A held
all the dates and column B would be a random time for the ajacent date.

What I want to do is set up a sheet with a years worth of dates and generate
a unique random 24 hr time for testing equipment on that date.

Any ideas??

Thanks, Steve

 

[Gord Dibben]

Steve

In B1 enter =RAND()

Double-click on the fill handle to copy down to end of data in column A.

Format as Time.

Copy column B and Paste Special(in place)>Values>OK>Esc.

Gord Dibben Excel MVP