Create Random Times of Day in Excel 2003-2013
In Excel, one day = 1
7AM = 7/24 845AM = 8.75/24
Enter the formula:
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.