Hi,
I was really hoping that somebody with better excel skills that me might be able to help! I'm trying to generate a list of random times between 21:30 and 02:30am for my research and I can't seem to do it in excel.
I've been able to generate random times that don't go past midnight on the same day using this formula:
=TIME(21,30,0)+RAND()*TIME(22,30,0)-TIME(21,30,0))
If anyone could help me then I would really appreciate it!
Best wishes
Bookmarks