Okay, try this:
=IF(AND(MONTH(B2)>3,MONTH(B2)<11)),IF(G2>=--"20:00:00",I2,0),IF(G2>=--"18:00:00",I2,0))
Hope this helps.
Pete
Okay, try this:
=IF(AND(MONTH(B2)>3,MONTH(B2)<11)),IF(G2>=--"20:00:00",I2,0),IF(G2>=--"18:00:00",I2,0))
Hope this helps.
Pete
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks