now I have another issue:
A new piece of code that I have introduced in this script now autogenerates "real" minutes (60 to an hour) between 5:20 am and 10:30 pm.
<=> For one field (>interval_hr<) in the code following this, I need to split out the hours:
- One "2hr-interval" during the day is 10am, the next is 12am
=> The minute-intervals I have inbetween there are all from 10:01 to 11:59
=> The hr-intervals should be 11 and 12
How to split out the hour-part now from the minute-intervals (if I could do this, then just adding 1 would be enough)
Here is the code that generates these intervals:
Time($(vShiftStart) + Time#('00:01:00')*(IterNo()-1), 'hh:mm') as Interval_Min
While Time($(vShiftStart) + Time#('00:01:00')*(IterNo()-1), 'hh:mm') <= $(vShiftEnd);
I tried the Hour() function, but then I'd end up with the "hour-intervals" 11, 12 and 13.
Can anyone help me here?
Thanks a lot!