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..

1464:46:47

<tbody>
</tbody>

227:34:55

<tbody>
</tbody>

79:36:54

<tbody>
</tbody>

591:12:10

<tbody>
</tbody>

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...