change the time in now()

[lezawang]

Hi
I want to generate different date and time to fill a column with different data. So I entered the formula below and then autofill the column. I ended up with different date but same time!! how can I change the time? thank you.

=now() - randbetween(0,1000)

 

[OGCV1]

Hi
I want to generate different date and time to fill a column with different data. So I entered the formula below and then autofill the column. I ended up with different date but same time!! how can I change the time? thank you.

=now() - randbetween(0,1000)

Try adding -rand() to the end to become:

=now() - randbetween(0,1000) - rand()

The time is effectively a decimal on the end of the number (the number being the date)