Random Time

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Random time 1
advice on rounding or ceilng a 24 hour time value 3
Round Date & Time 1
Tennis Schedule - Schedule players randomly 5
Start Time to End Time... Minutes On Each Hour... How to distribute proportionately? 5
Randomizing 3
Rounding time 2
Excel Formula Bar Time Display Format 2

Back
Top