Convert Letter to Number then add together

I'm working on a form for payroll, basically I have a layout of Sunday - Saturday along with Vacation column, AI day column and Holiday with the option of how many hours the employee worked that day, a V for a vacation day, an A for an Attendance Incentive day or a H for a Holiday. I know how to convert the letters into numbers and add them together but what I can't seem to get to work is returning a blank cell if there is no number or if the total = 0.

Please Login or Register  to view this content.

The above code works fine but it always leave a "0" in the cell if there are no V's during the particular week. If I remove the "0" and leave it as "" the code no longer works.

Please Login or Register  to view this content.

I have tried variations of using SUM but no luck. I greatly appreciate any help or tips on a working version of this formula.

First, why is it so complicated using Code-78..
Why not just put 8 ?
=IF(B2="","0",(IF(B2="V",8)))+IF(C2="","0",(IF(C2="V",8)))

Anyway, you should be able to utilize countif for this as well.
=COUNTIF(B2:C2,"V")*8

And if none of them are "V", leave it ""
Try
=IF(COUNTIF(B2:C2,"V")=0,"",COUNTIF(B2:C2,"V")*8)

@Jonmo1
Thank You! I was just way over thinking this... It works perfect.

You're welcome.