AnsweredAssumed Answered

Start End questions

Question asked by auburSNC on Nov 20, 2019
Latest reply on Nov 20, 2019 by dougbrowning

Am using a Start and End question in order to calculate the time required to fill in the form. However, since I have allowed to make copies of submitted records as new records, the Start value is never updated at the start of a new data input, only the End value.

To avoid this problem, I thought of calculating the elapsed time with the CreationDate but I don't know how to insert it in the calculation column of my XLSform


I had success using int((decimal-date-time(${end_time}) - decimal-date-time(${start_time)) * 24*60*60)

but no luck with int((decimal-date-time(${end_time}) - decimal-date-time(${CreationTime)) * 24*60*60)