How to get sequence of time between two number and extracted by minute

Hello. I need some help getting a sequence from two time number.

Supposedly the two number are “time_start” and “time_end”
time_start : 8:00 AM
time_end : 11:00 AM

the usual sequence that i can get would be 8:00, 9:00, 10:00, 11:00

however, in this case, i need to get a sequence extracted by minutes of duration

for example, if
time_start : 8:00 AM
time_end : 11:00 AM
duration : 30 mins

I want to have a sequence of 8:00, 8:30 ,9:00, 9:30, 10:00, 10:30, 11:00 as a list sequence

Is there any way anyone can help me figure out formula here

I’m not at the computer, so I can’t test it, but something like this should work: sequence(time_start, time_end,duration)

2 Likes

hi, how silly i am, maybe i was thinking to much of the way. that’s actually work. Thanks a lot

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.