How to create a time interval of 5 minutes with a starting time 00:00

#1

I need data of 5 minutes time interval but it should go as 00:05, 00:10…23:50,23:55,24:00.
I did some research and understood one way to do is using formula and setting command as " now().utc-minutes((100-__id)*5)" but it gives me random 00:48, 00:53, etc as it picks up current time.

so is there any way I can set up starting time and then get interval data

#2

Welcome to Mockaroo!

I’ve created a schema for you to check out that contains 2 fields. You can manipulate the increment5 field to display appropriate timestamp but this should give you an idea of how to accomplish your task.

#3

Here’s my solution: