Latest Contributions by Jim-Moore

Hi @bhariadi  Thanks for providing your XLSForm. Please see attached a simplified XLSForm that attempts to solve your problem using the count() function, and also by rearranging the questions slightly. One thing to note here is that I've avoided using aggregate functions (sum, count, etc.) inside the repeat that the function is aggregating. Please see the Survey123 Tricks of the Trade: Repeats blog post for some great info, as well as the documentation on repeats. Hope this useful, please let me know if this works for you. Best, Jim ... View more

Hi @JavierCMartínezPrieto  Are your entry and exit times entered using the time question type? If so, you can use something like the following to get the duration in minutes: (decimal-time(${exit_time}) - decimal-time(${entry_time})) *24 *60 Note that both time questions are in the same 24-hour period, so for example, if you enter 10:00pm for the entry and 2:00am for the exit, the calculation will result in -1200 minutes (i.e. back in time 20 hours). If you want your entry and exit times to cross from one day into the next, you could add the date to the value. One way to achieve this would be to use the dateTime question type instead for entry and exit, then use a calculation like: (decimal-date-time(${exit_datetime}) - decimal-date-time(${entry_datetime})) *24 *60 If you prefer to use the time question type, one option could be to add 24 hours to the exit time, if that time is less than the entry time. Expression could be something like: if(${exit_time} > ${entry_time}, (decimal-time(${exit_time}) - decimal-time(${entry_time})) *24 * 60, ((decimal-time(${exit_time}) - decimal-time(${entry_time})) *24 * 60) + 1440) One issue with this method is you would be relying on the user to enter the times correctly and making the assumption that they understand they're entering a time for the following day. It also wouldn't account for an exit time that was more than one day in the future (must be in the next 24 hours only). For this reason, the dateTime option is perhaps more reliable. Note these examples are in minutes but you could drop the *60 to get hours, but you might need to use the round() function to get a suitable result. For more help, see the Dates and Times sample XLSForm in Survey123 Connect, and check out the Dates and Time in Survey123 blog post. Hope this helps,  Best, Jim   ... View more