formula require..basis on two condition..

[VBABEGINER]

Hi All,
I need formula help..

Total count of data is, 90,000 or 95,000 max.

In my Col A, i have Types and the type names are..

NA
MR
MRR
RNL

In my Col B, i have Time (HH:MM:SS), some example for this..

[TABLE="width: 225"]
<tbody>[TR]
[TD="class: xl109, width: 225"]1464:46:47[/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="width: 225"]
<tbody>[TR]
[TD="class: xl111, width: 225"]227:34:55[/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="width: 225"]
<tbody>[TR]
[TD="class: xl111, width: 225"]79:36:54[/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="width: 225"]
<tbody>[TR]
[TD="class: xl111, width: 225"]591:12:10[/TD]
[/TR]
</tbody>[/TABLE]

note:-
1. output require in Col C.


condition's to make formula..

1. if its MR..

TAT = 4 hours per request.
output = 0 hr - 1 hr, 1 hr - 2 hr, 2 hr - 3 hr, 3 hr - 4 hr,....,23 hr - 24 hr.

2. if its MRR..

TAT = 1.5 hours per request.
output = 0 - 30 min, 30 min - 60 min, 60 min - 90 min,....

3. if its RNL..

TAT = 24 hours per request.
output = 0 - 8 hrs, 8 hrs - 16 hrs, 16 hrs - 24 hrs, Greater Than 24 Hrs



My team wants this type of output...I really don't understand, how do i achieve this by formula...can anyone help on this topic..

 

[VBABEGINER]

I appreciate help on this please..

Hi All,
I need formula help..

Total count of data is, 90,000 or 95,000 max.

In my Col A, i have Types and the type names are..


In my Col B, i have Time (HH:MM:SS), some example for this..


note:-
1. output require in Col C.


condition's to make formula..

1. if its MR..

TAT = 4 hours per request.
output = 0 hr - 1 hr, 1 hr - 2 hr, 2 hr - 3 hr, 3 hr - 4 hr,....,23 hr - 24 hr.

2. if its MRR..

TAT = 1.5 hours per request.
output = 0 - 30 min, 30 min - 60 min, 60 min - 90 min,....

3. if its RNL..

TAT = 24 hours per request.
output = 0 - 8 hrs, 8 hrs - 16 hrs, 16 hrs - 24 hrs, Greater Than 24 Hrs



My team wants this type of output...I really don't understand, how do i achieve this by formula...can anyone help on this topic..

 

[VBABEGINER]

Dear board member's, I really appreciate help on this...can any one reply, so i can describe more, if needed..

Hi All,
I need formula help..

Total count of data is, 90,000 or 95,000 max.

In my Col A, i have Types and the type names are..


In my Col B, i have Time (HH:MM:SS), some example for this..


note:-
1. output require in Col C.


condition's to make formula..

1. if its MR..

TAT = 4 hours per request.
output = 0 hr - 1 hr, 1 hr - 2 hr, 2 hr - 3 hr, 3 hr - 4 hr,....,23 hr - 24 hr.

2. if its MRR..

TAT = 1.5 hours per request.
output = 0 - 30 min, 30 min - 60 min, 60 min - 90 min,....

3. if its RNL..

TAT = 24 hours per request.
output = 0 - 8 hrs, 8 hrs - 16 hrs, 16 hrs - 24 hrs, Greater Than 24 Hrs



My team wants this type of output...I really don't understand, how do i achieve this by formula...can anyone help on this topic..

 

[VBABEGINER]

Dear All, closing this thread...Thanks...