Support Board

Date/Time: Fri, 20 Sep 2024 09:37:28 +0000

Post From: Syntax in Alert for the study "Bar Time Duration"

[2014-10-01 05:10:27] Link To Thread - Link To Post [Go To First Post]
Sawtooth - Posts: 4091
The output of the Bar Time Duration is in SerialDateTime format, without the date. This means you must convert the time to this format. One way is to use the TIMEVALUE spreadsheet function, like this: =ID1.SG1>TIMEVALUE("00:05:00") Another way to do it would be: =ID1.SG1>5/1440 You had the correct idea to try 1/12 of an hour, but the format is based on a portion of a 24 hour day, not an hour. Since you want 5 minutes, and since there are 1440 minutes in a 24 hour day, 5/1440 gives you the correct value.