ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   I want to generate random times (every couple of hours) for dates (https://www.excelbanter.com/excel-worksheet-functions/134205-i-want-generate-random-times-every-couple-hours-dates.html)

Daniel Hartman

I want to generate random times (every couple of hours) for dates
 
I want to generate random times (every couple of hours) for dates. For
example, we have a security exercise that is randomly generated for given
dates, or every day. Reply to:

Gary''s Student

I want to generate random times (every couple of hours) for dates
 
Enter:
=today()+rand()
to get a random time for today

format custom:
m/d/yyyy hh:mm
--
Gary's Student
gsnu200709


"Daniel Hartman" wrote:

I want to generate random times (every couple of hours) for dates. For
example, we have a security exercise that is randomly generated for given
dates, or every day. Reply to:



All times are GMT +1. The time now is 05:17 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com