Login Page - Create Account

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.