Support Board
Date/Time: Wed, 27 Nov 2024 21:25:17 +0000
Post From: Syntax in Alert for the study "Bar Time Duration"
[2014-10-01 05:10:27] |
Sawtooth - Posts: 4120 |
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. |