How to add a random number of minutes to an existing time in excel

[ola97316]

Hi

I need to add a range of minutes (1-60) to an existing time in excel - i already have a date (column D) and i need to add between 1 and 60 minutes at random to that time.
Does anyone know how can I achieve that?

Thanks
Ola

 

[Jon von der Heyden]

Try:

=D2+RANDBETWEEN(1,60)/24/60

 

[Legacy 456155]

In c2, place this formula.
=B2 + RANDBETWEEN(1,60) * 0.000694
The 0.000694 represents one minute.

 

[Jon von der Heyden]

=B2 + RANDBETWEEN(1,60) * 0.000694

I would caution against using that because 1 minute is 1/24/60, which is 0.000694444 (recurring). Cutting short at 6th DP is prone to calculate results including seconds. That said, the OP might not mind have seconds added to the time value.

 

[Legacy 456155]

I understand. Thanks!

 

[ola97316]

Thanks a lot - this is exactly what i needed!!