Clearing scheduled work hours for weekends.

[Phil B.]

Unfortunately, this function comes back with a 7.5 or FALSE for both Sat and
Sun.

 

[Baffled]

Hi there
I would use this formula
=IF(B1="sat",0,IF(B1="sun",0,7.5))

See if that works
D

 

[David Biddulph]

Does B1 actually contain the text "Sat", or is it a date formatted as ddd?
If the latter, change Shane's formula from
=IF(OR(B1="Sat",B1="Sun"),0,7.5)
to
=IF(OR(TEXT(B1,"ddd")="Sat",TEXT(B1,"ddd")="Sun"),0,7.5)

 

[Tom Hutchins]

Shane's formula works if your DAYs are text values or date values formatted
using the TEXT function. If, instead, your DAYs are actual date values
displayed using custom formats, then a formula like this should work:

=IF(OR(WEEKDAY(B1)=1,WEEKDAY(B1)=7),0,7.5)

This assumes that the first day is in cell B1.

Hope this helps,

Hutch

 

[ShaneDevenshire]

Hi,

As correctly stated by a number of responders, the formula will work IF your
cells really contain Sat and Sun as mentioned in the original email.

If the entries are actual dates then here is a really short formula:

=IF(MOD(A1,7)>1,7.5,0)

 

[Teethless mama]

This one even shorter.

=(MOD(A1,7)>1)*7.5

Hi,

As correctly stated by a number of responders, the formula will work IF your
cells really contain Sat and Sun as mentioned in the original email.

If the entries are actual dates then here is a really short formula:

=IF(MOD(A1,7)>1,7.5,0)

 

[Phil B.]

And the winner goes to Teethless mama!
It worked . . . THANKS to all!