I was talking with a workmate of mine and he mentioned that he is a swimming coach.
He told me that it’s difficult to record swimming times in Excel.
His approach was to record Minutes, Seconds and Splits (Split Seconds) as separate columns. Now, I can only imagine what sort of frustrating (if not impressive!) formulas this led to.

1. Excel For Mac Rtd Functions Think Or Swim Video
2. Excel Rtd Function Not Working
3. Excel For Mac Rtd Functions Think Or Swim Download
4. Excel For Mac Rtd Functions Think Or Swim

1. I'm usign the RTD function in excel to retrieve data from Thinkorswim. The data comes in as text (I presume, since its on the left side of the cell), I need the data to be number, so I can use it in calculations. See attached spreadsheet for example (you need thinkorswim to get the function to work).
2. Take A Sneak Peak At The Movies Coming Out This Week (8/12) 2021 BRIT Awards highlights; Meet Noah Centineo, Hollywood’s (and everyone’s) dream boyfriend.

Excel For Mac Rtd Functions Think Or Swim Video

Edit: The tos.rtd is in my 'inactive application add ins' list but there is no option to activate it? Running Excel 2013 on windows 10. Ok so its specifically a problem with Excel 2013 not wanting to use the rtd plug-in. Many hours fighting RTD not working in Excel 2013 64-bit.

I explained to him that Excel can store Split Seconds right out of the box.
Just format the cell as mm:ss.00

Great! That’ll work.

Being the thinker, he suddenly realised typing in the times would be even more difficult than before. It’s that fiddly colon key :

“Is there a way to type the times with a decimal point as a separator?” he asked.

Fair enough question. His times on paper are written as dot separated.

Fun! Let’s write a formula!

Excel Rtd Function Not Working

I figured out there were 3 formats of time:
23 which means 23 seconds
23.45 which means 23.45 seconds
1.23.45 which means 1 minute and 23.45 seconds
The hour portion of the time is never reached.

So for a time typed into A1, the following formula turns it into an Excel time.
=IF(LEN(A1) – LEN(SUBSTITUTE(A1, “.”, “”)) = 2, TIMEVALUE(“00:” & SUBSTITUTE(A1, “.”, “:”, 1)), TIMEVALUE(“00:00:” & A1))

Excel For Mac Rtd Functions Think Or Swim Download

Excel For Mac Rtd Functions Think Or Swim

Again, the cell has a custom format of mm:ss.00