AnsweredAssumed Answered

Adding up elapsed time

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

Hi

 

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

 

I'm having trouble working out converting m.ss 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.

Outcomes