Excel Formulas to Generate Random Times at Specific Intervals!!
Tags: excelformula, excelformulas
Published: 2021-07-12 03:21:06

---
title: Excel Formulas to Generate Random Times at Specific Intervals!!
published: true
date: 2021-07-06 11:46:17 UTC
tags: ExcelFormula,Excelformulas
canonical_url: https://geekexcel.com/excel-formulas-to-generate-random-times-at-specific-intervals/
---

In the previous post, we have learned the formulas to **[generate the random text values in Excel](https://geekexcel.com/excel-formulas-to-generate-random-text-values-useful-tricks/)**. Similarly, here we will show the formulas to **generate the random times at specific intervals in Excel**. Let’s see them below!! Get an official version of ** MS Excel**  from the following link: [https://www.microsoft.com/en-in/microsoft-365/excel](https://www.microsoft.com/en-in/microsoft-365/excel)

[![Generate Random times at specific intervals](https://geekexcel.com/wp-content/uploads/2021/07/Generate-Random-times-at-specific-intervals.png)](https://geekexcel.com/excel-formulas-to-generate-random-times-at-specific-intervals/generate-random-times-at-specific-intervals/#main)<figcaption id="caption-attachment-48615">Generate Random times at specific intervals</figcaption>

## Generic Formula:

- You can use the below formula to generates the random times when you have a time interval in Excel.

**=[FLOOR](https://geekexcel.com/how-to-use-excel-floor-function-in-office-365-with-examples/)([RAND](https://geekexcel.com/how-to-use-excel-rand-function-in-office-365-with-examples/)(),”0:15″)**

## Syntax Explanations:

- **FLOOR** – In Excel, the **[FLOOR Function](https://geekexcel.com/how-to-use-excel-floor-function-in-office-365-with-examples/)** helps to round a number down to the nearest multiple of significance.
- **RAND** – This function is used to return the random number between 0 and 1. Read more on the **[RAND function](https://geekexcel.com/how-to-use-excel-rand-function-in-office-365-with-examples/)**.
- **Comma symbol (,)** – It is a separator that helps to separate a list of values.
- **Parenthesis ()** – The main purpose of this symbol is to group the elements.

## Practical Example:

Refer to the below example image.

- Here we will enter the input time interval in **Column B**.
- Now we need to generate the random times based on the given time intervals.

![Input Ranges](https://geekexcel.com/wp-content/uploads/2021/07/Input-Ranges-23.png)<figcaption id="caption-attachment-48616">Input Ranges</figcaption>

- Select any cell and type the above-given formula.

![Enter the formula](https://geekexcel.com/wp-content/uploads/2021/07/Enter-the-formula-22.png)<figcaption id="caption-attachment-48618">Enter the formula</figcaption>

- Finally, press the ** ENTER**  key, you can get the result as shown below.

![Result](https://geekexcel.com/wp-content/uploads/2021/07/Result-23.png)<figcaption id="caption-attachment-48617">Result</figcaption>

## Verdict:

So yeah guys this is **how you can generate the random times at specific intervals in Excel**. Leave a **comment** or **reply** below to let me know what you think!

Thank you so much for visiting  **[Geek Excel](https://geekexcel.com/)!! **If you want to learn more helpful formulas, check out [**Excel Formulas**](https://geekexcel.com/excel-formula/) **!! **

### Read Ahead:

- **[Excel Formulas to Get the Profit Margin Percentage ~ Quickly!!](https://geekexcel.com/excel-formulas-to-get-the-profit-margin-percentage/)**
- **[How to Insert a Date or Formatted Date in Excel Office 365?](https://geekexcel.com/how-to-insert-a-date-or-formatted-date-in-excel-office-365/)**
- **[Excel Formulas to Generate Random Number from Fixed Set of Options!!](https://geekexcel.com/excel-formulas-to-generate-random-number-from-fixed-set-of-options/)**
- **[Excel Formulas to Get the Percentage Discount ~ Useful Tricks!!](https://geekexcel.com/excel-formulas-to-get-the-percentage-discount/)**