Consecutive Time and date

#1

Hi,

I’m trying to generate data for health monitor readings which should ‘collect’ data throughout the day.

How do I generate data to show values being generated every 30mins for 1 year?

e.g. Data should be collected everyday in 30min increments from 01/06/2019-01/08/2020 ?

Thanks!

#2

I suggest using Row Number with an inline formula that adds seconds from a constant date. Here’s an example: https://mockaroo.com/0bd78200