Support Board

Date/Time: Sun, 11 May 2025 15:13:56 +0000

Post From: Speadsheet study issue

[2014-10-24 14:15:30] Link To Thread - Link To Post [Go To First Post]
User48557 - Posts: 138
I have this formula =IF(AND(WEEKDAY(A3)=1,A4-INT(A4)<TIMEVALUE("20:00:00"),A3-INT(A3)>=TIMEVALUE("20:00:00")),B3,K4) It draws a horizontal line when the Cotton market opens on Sunday at 10 pm, I am trying to tweak this formula so it works on the Cocoa Monday open at 3:45 am, but i am having trouble. It is not working Any suggestions for a formula that works?