Forum Discussion
Convert hh:mm:ss,cc into seconds
Hello, I try to convert hh:mm:ss,cc into seconds to calculate speed in km/h from 100m to Marathon. I succeed if hh:mm:ss but I have an error if I add cc. Could you please help me?
Thank you for your help.
I choose to write numbers (h , mn , sec, cc) in differents cells to transform it into Glide AP. It's easier to write numbers rather than "," or ";"
What i'd like to do is to write 2 elements (time, distance or speed) and calculate the one is missing.
I don't know how to send you concrete example
I choose to write numbers (h , mn , sec, cc) in differents cells to transform it into Glide AP. It's easier to write numbers rather than "," or ";"
What i'd like to do is to write 2 elements (time, distance or speed) and calculate the one is missing.
I don't know how to send you concrete example
XCerati Here are some formulas. Normally I would put all the entries on the same row, but I put the last 3 down and to the left for ease of viewing.
Calculated values have a heading that is highlighted.
Yes, the calculated "Entered Time" shows zero even when the user enters no time (duration, or elapsed time). The formulas in G3 and G12 could be changed to conditionally replace that with an empty string, like the other formulas do, but I thought I would start you off with the simpler version.