That is amazing. Thanks very much Joshi and that you too as well Paul.
On Monday, 30 November 2015 09:16:49 UTC-5, Vabz wrote:
>
> put this formula in I2 & drag down:
>
>
> =IF(COUNTIF($B$2:B2,B2)=1,RANDBETWEEN(420,480)/1440,RANDBETWEEN(I1*1440+TIME(0,31,0)*1440,I1*1440+TIME(0,55,0)*1440)/144
---
From: Vaibhav Joshi
To: "excel-macros@googlegroups.com"
Sent: Monday, November 30, 2015 9:16 AM
Subject: Re: $$Excel-Macros$$ Random Time Problem
put this formula in I2 & drag down:
=IF(COUNTIF($B$2:B2,B2)=1,RANDBETWEEN(420,480)/1440,RANDBETWEEN(I1*1440+TIM
put this formula in I2 & drag down:
=IF(COUNTIF($B$2:B2,B2)=1,RANDBETWEEN(420,480)/1440,RANDBETWEEN(I1*1440+TIME(0,31,0)*1440,I1*1440+TIME(0,55,0)*1440)/1440)
Cheers!!
On Wed, Nov 25, 2015 at 1:44 AM, Bill Q wrote:
>
>
> I gave this my best shot - but I am not satisfied with it.
>
> PSA.
>
> *
*“Do all the good you can,By all the means you can,In all the ways you
> can,In all the places you can,At all the times you can,To all the people
> you can,As long as ever you can.” - John Wesley*
> ---------
>
> --
> *From:* Bill Q >
> *To
aces you can,
At all the times you can,
To all the people you can,
As long as ever you can.” - John Wesley
-
From: Bill Q
To: MS EXCEL AND VBA MACROS
Sent: Tuesday, November 24, 2015 3:14 PM
Subject: $$Excel-Macros$$ Random Time Problem
I gave
I gave this my best shot - but I am not satisfied with it.
PSA.
* What I have are dates between November 15, 2015 to January 16, 2016
* Each date will have 16 radio "spots".
* These spots are to be anywhere between 07:00 to 21:00.
I was able to randomize the time somewhat with the final pro
