About primmer300174

primmer300174 · ‎06-13-2025

I have to convert each duration into 30 minute intervals for comparing against the scheduled activity which is in 30 minute intervals. This is what the Resource planning area have given me and will not change this. I am trying to work out how many agents I would have (whether fully or partly) in that 30 minute interval. I have examples where a break has been place at 10:55:00 - 11:05:00 which would mean I need to have the MyStart as 10:55:00 - MyEnd 11:05:00 and then an additional row that would say MyStart as 11:05:00 and MyEnd as 11:30:00. Hope this make sense and clarifies the confusion.

primmer300174 · ‎06-13-2025

Firstly, thank you for your advise, noted and will amend current and future codes to prevent the "magic" numbers etc. Makes sense to me but like you said, anyone else looking at it may not understand. This is almost what I need. for row 5, where it says MyEnd at 17:15:00, think need to be 17:00:00 and then an additional to say MyStart 17:00:00 and MyEnd to say 17:15:00

primmer300174 · ‎06-13-2025

I'm doing a loop and output so that it gives every iteration for the 30 mins interval I'm requiring

primmer300174 · ‎06-13-2025

The ask of me is to have interval data per agent for productivity. but if the interval ends at 16:45:00, that would be classed as 0.5 for that interval as they are not productive for the whole 30 min interval. Hope this clarifies what I have asked for

primmer300174 · ‎06-13-2025

Apologies if this is already been posted, I'm new to this. I'm trying to get 30 min interval data or to the end time for Agent activity for work. the code I have is :- data test; set schedule2; format Mystart MyEnd tod8.; do Mystart = Start to Stop by 1800; MyEnd = MyStart + 1800; output; end; run; This works for the most part, but it's not working if the interval end time is like 16:45:00. This is what I have :- 02-Jun-25 Sick 09:00:00 16:45:00 465 16:00:00 16:30:00 02-Jun-25 Sick 09:00:00 16:45:00 465 16:30:00 17:00:00 02-Jun-25 Meal 16:45:00 17:15:00 30 16:45:00 17:15:00 02-Jun-25 Meal 16:45:00 17:15:00 30 17:15:00 17:45:00 But what I want is :- 02-Jun-25 Sick 09:00:00 16:45:00 465 16:00:00 16:30:00 02-Jun-25 Sick 09:00:00 16:45:00 465 16:30:00 16:45:00 02-Jun-25 Meal 16:45:00 17:15:00 30 16:45:00 17:00:00 02-Jun-25 Meal 16:45:00 17:15:00 30 17:00:00 17:15:00 I know I am missing something but I cannot figure it out. Can someone please assist.

Online Status	Offline
Date Last Visited	‎06-20-2025 04:32 AM

Re: Working with Time Intervals

Re: Working with Time Intervals

Re: Working with Time Intervals

Re: Working with Time Intervals

Working with Time Intervals

Re: Working with Time Intervals

Working with Time Intervals

Re: Working with Time Intervals

Re: Working with Time Intervals

Re: Working with Time Intervals

Re: Working with Time Intervals

Working with Time Intervals