Login Page - Create Account

Home >> Support Board

Support Board

Date/Time: Thu, 25 Apr 2024 04:25:38 +0000

How to Post a Message for Support

Post From: Spreadsheet

[2019-07-11 23:12:54]
[Go To First Post]
AndreyPoroshin - Posts: 102
Hello, please help to deal with the time data sorting formula.
I need to break 24 hours into 3 zones to track the volume. At night the volume is less, in the afternoon it is more
I made three columns, but they come into conflict with each other, of course it would be better to put all this in one column.
US TRADES
R =AND(OR(FRACTIME(J41)<TIMEVALUE("08:29:01"),FRACTIME(J41)>TIMEVALUE("15:54:55")),G3>1500)
EU TRADES
S =AND(OR(FRACTIME(J41)<TIMEVALUE("00:00:00"),FRACTIME(J41)>TIMEVALUE("08:29:00")),G3>400)
ASIA TRADES
T =AND(OR(FRACTIME(J41)<TIMEVALUE("17:00:00"),FRACTIME(J41)>TIMEVALUE("23:59:59")),G3>400)

=IF(OR(R3>0,S3>0, T3>0), E3, O4)