Oh, no. I meant I knew there had to be a formula that would do it in one
format, rather than using two... :)
You supplied it.
************
Anne Troy
VBA Project Manager
www.OfficeArticles.com

"Roger Govier" wrote in message
...
Hi Anne
I hadn't seen your response when posting, but looking at it now, you did
say the same thing. I guess I just gave the formula rather than the
reason.
You "thunk" correctly<vbg.

Regards

Roger Govier


Anne Troy wrote:
I knew it! (That's why my reply said "I think".) Thanks, Roger.
************
Anne Troy
VBA Project Manager
www.OfficeArticles.com

"Roger Govier" wrote in message
...

Hi Steve

=OR(G6="v",G6="hv")

Regards

Roger Govier


Steve wrote:

Anne:

One more question for you. I also have a conditional format saying that
if formula is =G6="v" then the cell would turn color. How would I
incorporate that into the HV scenario?

"Anne Troy" wrote:



I think you're telling us you can't figure out a code for half days? I
mean... if it's a half day vacation, why not HV? Then:
=countif($F6:$CQ6, "V")+(countif($F6:$CQ6, "HV")*.5)
?
************
Anne Troy
VBA Project Manager
www.OfficeArticles.com

"Steve" wrote in message
...


I am using the count function for attendance tracking of Vacation,
Personal
Time, & Sick Time. (Example: =COUNTIF($F6:$CQ6, "V")

Problem is that, now I need to be able to do half days. I have tried
many
different formulas/ways to incorporate the half day scenario even
without
using the count function with no success.

Do anybody have any ideas?