Hi Folks,
Appreciate your help here, I have few items needed below for my reports and refer to requirements and concerns.
Is there a way I can automatically compute the time at B (1st Worksheet) to the corresponding Engineer Grade and Rate per hour base from Engineer name (Section A)? My initial approach here; there is another worksheet (see below 2nd Worksheet) this is were Vlookup the Eng Name (1st Worksheet) and will compute the hours on B (1st Worksheet) base on the rate of the engineer on the scorecard (see worksheet 2 scorecard)l If this is the case I will no longer convert the time at B to C (1st Worksheet) to value below.
RESULTS NEEDED FOR REPORTING:
C - Time Effort - how can i compute from the B (HH:MM) that will convert this to data below (just for computation)
D - Engr Type (1st Worksheet) - will lookup the grade of engineer from worksheet 2 (i.e. SCOF) this will vlookup base from name
E - COST SUPPORT(1st worksheet) -will compute for the hours from B (or via C ) that will reference the Eng Name and will compute on engineer type (see sample below worksheet 1)
(WORKSHEET 2)
<tbody>
</tbody>
(WORKSHEET 2)
<tbody>
</tbody>
Appreciate your help here, I have few items needed below for my reports and refer to requirements and concerns.
Is there a way I can automatically compute the time at B (1st Worksheet) to the corresponding Engineer Grade and Rate per hour base from Engineer name (Section A)? My initial approach here; there is another worksheet (see below 2nd Worksheet) this is were Vlookup the Eng Name (1st Worksheet) and will compute the hours on B (1st Worksheet) base on the rate of the engineer on the scorecard (see worksheet 2 scorecard)l If this is the case I will no longer convert the time at B to C (1st Worksheet) to value below.
RESULTS NEEDED FOR REPORTING:
C - Time Effort - how can i compute from the B (HH:MM) that will convert this to data below (just for computation)
D - Engr Type (1st Worksheet) - will lookup the grade of engineer from worksheet 2 (i.e. SCOF) this will vlookup base from name
E - COST SUPPORT(1st worksheet) -will compute for the hours from B (or via C ) that will reference the Eng Name and will compute on engineer type (see sample below worksheet 1)
(WORKSHEET 2)
A | B | C | D | E | F | G | |
1 | Eng Name | In HH:MM | Time Effort | Engr Type | Cost Support | ||
2 | John | 00:45 | 0.75 | SCOF | 46.88 | ||
3 | Tol | 01:55 | 1.55 | COF | 87.58 | ||
4 | Joe | 03:15 | 3.15 | COF | 177.98 | ||
5 | John | 02:11 | 2.11 | SCOF | 131.88 | ||
6 | |||||||
7 | |||||||
<tbody>
</tbody>
(WORKSHEET 2)
A | B | C | D | |
1 | Name | Consult Grade | Descript | Rate |
2 | John | SCOF | Sen Consult | 62.50 |
3 | Tol | COF | Consl Offshore | 56.50 |
4 | Joe | COF | Consl Offshore | 56.50 |
5 | ||||
6 |
<tbody>
</tbody>