loop through time range and replace variables

[backgun]

Hello
i've got a Makro which calls a link and it download a cvs file.
This link needs 6 variables to work, example:

h t t p s : //blabla.com/ startdate=var1 & starthour=var2 & startmin=var3 .. etc
would result in
h t t p s : //blabla.com/ startdate=2023/01/06 & starthour=23 & startmin=30.. etc
see picture

-now i need a download for each hour between a time range
the time range is given in the Column P,R,S

means:
get the var date out of the first row (timerange)
then call makro1
then replace the variables (var1,var2..) with the next time dates
then call again makro1
and so on until the last timerangecell reached.

hope s1 can help me out, thanks together

 

[backgun]

get the date out of the first row (timerange) store this into var1 (date) var2(hour) var3(minutes)
and add 1 hour to the given time and store this into var4,5,6
then call makro1
then replace the variables (var1,var2..) with the next time dates
then call again makro1
and so on until the last timerangecell reached.

 

[backgun]

any idea?