Is it possible random between time
Ex. - random between 01:23 - 02:08
and it give me different value between 01:23 - 02:08
Is it possible random between time
Ex. - random between 01:23 - 02:08
and it give me different value between 01:23 - 02:08
You can do this:
=RANDBETWEEN(A1*60*24,B1*60*24)/60/24
where A1 contains 01:23 and B1 contains 02:08 (proper Excel times, not text values). Format the result as [h]:mm
Hope this helps.
Pete
Hi ...
try this..
Formula:Please Login or Register to view this content.
Increase the number of "0" to get more accurate time.. like 1:23:01 to 2:07:59
Regards!
=DEC2HEX(3563)
If you like someone's answer, click the star to give them a reputation point for that answer...
It depends what sort of values you want, every minute, every second, every millisecond?
If you want every minute between those two times (including end points) try this formula
=RANDBTWEEN(83,128)/1440
format results cells as time values
Audere est facere
Thanks a lot Friends ur formula is working as i want
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks