I need to change this to generate random times from 0:00 to 5:00 in minutes.
Can you use the BETWEEN in this?=TEXT(RAND()*(9-6)/24+6/24,"MM:SS")
I need to change this to generate random times from 0:00 to 5:00 in minutes.
Can you use the BETWEEN in this?=TEXT(RAND()*(9-6)/24+6/24,"MM:SS")
Peace of mind is found in some of the strangest places.
Posting Permissions
Reply With Quote