Time If

[HOSAMNOOR]

Hi

How can i do that

If Time In cell A1>= 10.00 am then write " Open " in cell A2

If Time In cell A1>= 3.00 PM then Write " closed " in cell A2

Thank's

[DonkeyOte]

One Way:

=LOOKUP(HOUR(N(A1)),{0,10,15},{"","Open","Closed"})

[HOSAMNOOR]

Thank's soooo much

[HOSAMNOOR]

One More Question

If also today saturday or sunday then write " closed " in cell A2

Thank's

[daddylonglegs]

Not sure if you actually want today's date or a date in A1 but you could adapt DonkeyOte's formula like this

=IF(WEEKDAY(TODAY(),2)<6,LOOKUP(HOUR(A1),{0,10,15},{"","Open","Closed"}),"Closed")

[HOSAMNOOR]

Not sure if you actually want today's date or a date in A1 but you could adapt DonkeyOte's formula like this

=IF(WEEKDAY(TODAY(),2)<6,LOOKUP(HOUR(A1),{0,10,15},{"","Open","Closed"}),"Closed")

I Think Not ok

Thank's for your help

[HOSAMNOOR]

Not sure if you actually want today's date or a date in A1 but you could adapt DonkeyOte's formula like this

=IF(WEEKDAY(TODAY(),2)<6,LOOKUP(HOUR(A1),{0,10,15},{"","Open","Closed"}),"Closed")

would you please tell me how can i change the weekend on the code , for example if i want to change the " close " to be on teusday and friday ?

or if it on friday and saturday

how can i control that on the code

thanks

[daddylonglegs]

This formula will alway give "Closed" if today is Tuesday or Friday

=IF(OR(WEEKDAY(TODAY())={3,6}),"Closed",LOOKUP(HOUR(A1),{0,10,15},{"","Open","Closed"}))

In this part {3,6}

3 represents Tuesday and 6 Friday (1=Sunday throught to 7 = Saturday) so you can change that part to whichever numbers you want

[HOSAMNOOR]

Big Thank's