Random Time

S

SteveMcDowell19

I want to generate a randome 24 hr time for a given date. The time can be
rounded to the nearest hour or half hour. I am trying to create a sheet that
has a 1 year date column and a unique random time column for that date to
manage an equipment testing schedule.

Thanks for any help,

Steve
 
M

Myrna Larson

Just use the RAND() function and format as time. YOu'll probably want to
convert the formulas to their values so they won't continually recalculate. Do
that via Edit/Copy, then Edit/Paste Special and select the Values option.
 
Top