AnsweredAssumed Answered

Calculate total time when start and end times field type is text

Question asked by bweller on Oct 13, 2017
Latest reply on Oct 13, 2017 by bweller

I am playing with different ways to enter time and calculate total time. I am considering capturing time in a text format because I have noticed that the now() option can be buggy under certain circumstances (like if the survey crashes, the time refreshes to recovery time. Also, the species sighted time captured in a repeat section refreshes my route start time under some conditions). I am wondering if it is possible to calculate total time is the time is captured as text (military time). If so, how?

 

Many thanks.

Outcomes