How to quickly generate random time in Excel?
In Excel, in a common situation, most of us may need to insert random numbers, date or text strings as our desired. But sometimes, have you ever tried to insert times randomly in a range of cells? Actually, we can apply some formulas to insert random time into the worksheet.
The following formulas can help you to generate random time in a range of cells, please do as these:
Generate random time in Excel
Please enter the below formula into a blank cell, and then drag the fill handle down to the cells you want to get the times, see screenshot:
Generate random time between two times in Excel
If you want to generate random time between two given times, such as generate time from 11 o’clock to 15 o’clock, you can use below formula.
Type the following formula into a blank cell, and drag the fill handle over to the range that you want to insert the time.
And you will get the random time which between 11 o’clock and 15 o’clock. See screenshot:
Generate random time at specific intervals in Excel
To generate random times at specific intervals, such as random times at a 15-minute interval.To deal with this job in Excel, you can use the RAND and FLOOR functions within the TEXT function, please do as this:
Copy or enter the following formula into a blank cell, and then drag the fill handle down to the cells that you want to get the time.
Generate random date and time between two datetimes in Excel
Here is also a formula which can help you to generate random date and time in the worksheet.
Please enter or copy the below formula into a blank cell, then drag the fill handle to the cells that you want to insert the date and time.
If you are tired of the formulas, here, I can talk about an easy way to solve it. With Kutools for Excel’s Insert Random Data utility, you can quickly insert random numbers, date, time, and other text strings.
After installing Kutools for Excel, please do as this:
1. Select a blank range of cells that you want to insert random time.
2. Click Kutools > Insert > Insert Random Data, see screenshot:
3. In the Insert Random Data dialog box, click Time tab, and then enter the start time into the From box, and type the end time into the To box, see screenshot:
Tips: To insert some random distinct time, please check Unique values option.
4. Then click Ok or Apply button, the random time has been inserted into the cells. See screenshot:
More relative articles:
- Generate Random Date Between Two Dates
- When you use an Excel file, sometimes you want to generate random date for some purpose, of course, you can enter the date manually one by one, but if you need to insert multiple dates, this method will be time-consuming and boring. How to quickly generate random date on earth in Excel?
- Check If Time Is Between Two Times
- In Excel, how could you check if a specific time is between two given times? To check them one by one will waste lots of time, here, I will introduce some simple formulas to solve this job.
- Convert Time Format From 12 Hour To 24 Hour And Vice Versa
- When you work on Excel in your daily work, you may use different time format under different conditions, such as 12 hour format and 24 hour format as following screenshot shown. But, how could you convert time format from 12 hour to 24 hour and vice versa in Excel?
- Calculate Hours Between Times After Midnight
- Supposing you have a time table to record your work time, the time in Column A is the start time of today and time in Column B is the end time of the following day. Normally, if you calculate the time difference between the two times by directly minus "=B2-A2", it will not display the correct result as left screenshot shown. How could you calculate the hours between two times after midnight in Excel correctly?
You are guest
or post as a guest, but your post won't be published automatically.
- To post as a guest, your comment is unpublished.· 6 years agoThanks for the post, i really needed random hour, and this helped me a lot!!