Help needed with formula

K

karit68

I have a spreadsheet that I am using tracking the hours for our drivers
I would like for Excel to recognize when I put in a letter (such as
for vacation) a specific number of hours for that day. I have looke
through Excel books and online and I can't find exactly what I'
looking for. I'd appreciate any help that anyone can give.

Thanks!

Kar
 
J

JE McGimpsey

One way:

Assume hours in B2:J2.

K2: =SUM(B2:J2)+TIME(8,0,0)*COUNTIF(B2:J2,"v")
 
Top