AnsweredAssumed Answered

Adding up elapsed time

Question asked by nigelau on Jun 25, 2014
Latest reply on Jun 26, 2014 by disabled_winfried



I'm trying to let users enter brief time periods quickly in the format of (or more often - they will always forget the leading 0 in


I'm having trouble working out converting to a time field so I can add up the complete elapsed time for different segments. The idea was to split the minutes into their own field, the seconds into a different one, then have a background calculation work it out and convert to hh:mm:ss, which then could be summarised and added up.


I thought of using LeftValues but will have a variable amount of characters before the period, and LeftWords doesn't consider the period as a break.


Thanks for any help.