lezawang
Well-known Member
- Joined
- Mar 27, 2016
- Messages
- 1,805
- Office Version
- 2016
- Platform
- Windows
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)
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)