Im in need to do a report of calls per Timeframe, i will give some Infos what i mean.
what i have is the start time and the duration
Examples: format is yyyyddmmhh24miss;seconds
Based on that data i need to put the duration in propper Timeframes, the Frames are:
The Result should look like this
The duration should be sorted to the Timeframes, and if a call is on a weekend but going into a monday,
then the rest of the duration need to be sorted as well.
Im at the Beginning of writing the script,
i would Go with Date::Calc for the date calculations and a while duration > 0 loop with alot of IF's to split the duration into the propper slots.
A hint how to make it better is much aprechiated