Support Board

Date/Time: Mon, 25 Nov 2024 11:32:02 +0000

Post From: Spreadsheet Time Values

[2014-01-30 10:46:33] Link To Thread - Link To Post [Go To First Post]
sbsierra - Posts: 71
hi, you can use Cell J28 to disable autotrading =OR(J41-INT(J41)<TIMEVALUE("09:25:00");J41-INT(J41)>TIMEVALUE("17:45:00");AND(J41-INT(J41)>TIMEVALUE("11:45:00");J41-INT(J41)<TIMEVALUE("14:00:00"))) This will enable from 9:25 till 17:45, but disable from 11:45 till 14:00 regards, SB