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.