Timesheet formula to deduct unpaid time based on value in a column

I have a weekly timesheet that i need to have a cell fill with either 0, .5 or the sum of other cells based on a code.

I have attached a sample workbook.

Column D is where the code will be entered. Codes are H for Holiday, V for Vacation, S for Sick. I have formulas in column E to automatically put in 8 hours if those codes are used. Cell E21 should equal 0 in this case.
If a T or L is found in Column D, it should sum the amounts in column E for those rows which contain the T or L. If no values in column D and E20 is >=6, E21 should be .5, if <6, E21 should be 0.
This will do part of what I need but I can't make it work for the holiday,vacation and sick codes.

=IF(E65<6,0,IF(SUMIF(D49:D64,"<>",E49:E64)=0,0.5,SUMIF(D49:D64,"<>",E49:E64)))

Test Workbook.xlsx

How would the lookup handle multiple instances of the letter. Say they had two different unpaid travel times. Could it sum the multiple instances within the lookup table?

The problem with that scenario is, you would need another sheet with a separate row with 52 columns for each employee to look up each week, then apply 52 separate formulas to refer these lookups back to EACH time sheet.

(my apologies if you know how to do the following already).

A better solution would be to build your formulas on sheet 1 completely. i.e. in rows 20 - 23. Using the if formulas in rows 24-27 as and where necessary. Once this is complete select rows 20 - 27, click 'copy. Select the 2nd Employee tab, hold the shift key down and select your last employee tab. All of the sheets will be highlighted. Click 'Paste, this will paste the rows and formulas into every sheet. btw, all of the sheets need to be exactly the same format for this to work, if that is not the case, build sheet 1 completely, select the top left button in between the row #'s and column letters and follow the same copy paste procedure. Each employee will now have exactly the same sheet and formulas. (you would need to change employee names though).

See attached example.