Create Random Times of Day in Excel 2003-2013

Create Random Times of Day in Excel 2003-2013

In Excel, one day = 1

7AM = 7/24 845AM = 8.75/24

Enter the formula:

=7/24+RAND()*(8.75/24-7/24)

On the Home tab of the Ribbon, select ‘Time’ from the dropdown in the Number area.

This will generate a random time starting at 7am and continuing through 845am.