Day of week time control

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

vernon - 13 Jun 2007 15:46 GMT

Let's say I wanted something to occur at specific times (via DDE) on Sunday,
a different thing on Monday -Tue, Wed, Thurs, Fri Sat and continue over and
over.

I see how I can know the day and time, but to use it in a formula escapes
me.
The use is for a simple area based light control in my house.

Reply to this Message

Roger Govier - 13 Jun 2007 16:59 GMT

Hi Vernon

Maybe
=IF(AND(WEEKDAY(NOW())=1,HOUR(NOW())>=8,HOUR(NOW())<=17),"Switch
on","Switch off")

Signature

Regards

Roger Govier

> Let's say I wanted something to occur at specific times (via DDE) on
> Sunday, a different thing on Monday -Tue, Wed, Thurs, Fri Sat and
[quoted text clipped - 3 lines]
> escapes me.
> The use is for a simple area based light control in my house.

Reply to this Message