Time duration should fit in the recommended interval time ( Cumulative) and as per each category

[rajreddy]

Hi All,

Need help with the excel function in the attached sheet .. Please assist.

 

[rajreddy]

Hi All,
Can anyone please assist

 

[vletm]

rajreddy​

What are Your expected results below 'Open'?
... hmm?
Seems that You're still calculating Your expected results ...
Here other sample...
Check sheet2
You can select
cell E1 - Agent's name or by selecting Agent_name ... all names
cell E10 - Date
cell F10 - Steps (00:05,00:10,00:15,00:20,00:30,01:00)
to see something right side
ps. Macros have to be enabled.

 

[rajreddy]

I have simplified the requirement , need formulae from Cell L2 to L10 based the interval start and end ( I have provided sample output)
Please assist.

 

[rajreddy]

rajreddy​

What are Your expected results below 'Open'?
... hmm?
Seems that You're still calculating Your expected results ...
Here other sample...
Check sheet2
You can select
cell E1 - Agent's name or by selecting Agent_name ... all names
cell E10 - Date
cell F10 - Steps (00:05,00:10,00:15,00:20,00:30,01:00)
to see something right side
ps. Macros have to be enabled.

Thank you, this works - I have replied based on what are your results below open -- Sorry for not looking into the data.
I have got what I needed , thank you..

 

[rajreddy]

rajreddy​

What are Your expected results below 'Open'?
... hmm?
Seems that You're still calculating Your expected results ...
Here other sample...
Check sheet2
You can select
cell E1 - Agent's name or by selecting Agent_name ... all names
cell E10 - Date
cell F10 - Steps (00:05,00:10,00:15,00:20,00:30,01:00)
to see something right side
ps. Macros have to be enabled.

Thank you, this is a perfect solution. Appreciate your help