Assuming you're using column A, and each row is either the number of hours
worked, or a V or a X, then use a helper column, B, and insert this in B1
and copy down.......change the A1's to A2's if you have a header in Row 1,
and put this in B2.

=IF(A1="V",8,IF(A1="X",4,A1))

Vaya con Dios,
Chuck, CABGx3


"Brando" wrote in message
oups.com...
I'm tryng to build a spreadsheet to track employee vacations. How do I
sum 8 hours if a cell has a "V" entered and 4 hours if a cell has an
"X" entered?