Help needed with formula

  • Thread starter Thread starter karit68
  • Start date Start date
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
 
One way:

Assume hours in B2:J2.

K2: =SUM(B2:J2)+TIME(8,0,0)*COUNTIF(B2:J2,"v")
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Ignore text but count values in same cell 2
Creating a calendar function 1
Vacation accrual formula needed 2
Best way to pull data from several different sheets into a summary sheet 2
Need help with simple formula please 4
Formula 5
Time formula 5
Formula to return Vacation weeks 1

Back
Top