Countdown Timer

[nigelk]

Just out of curiosity, does anyone have problems extracting the minutes and seconds from the countdown timer?

[Euler]

I'm sure this was discussed and solved on another thread somewhere. Can't immediately find it.

[nigelk]

Found a couple of bits and pieces, but nothing definite.

Started a knowledge base. Hope it helps.

http://www.tradersandpunters.com/knowledge-base/

[burdo77]

Do u mean you want to convert the countdown timer to seconds? if so format another cell as general and times the cell of the countdown timer by 86400 which is the amount of seconds in a day.

[burdo77]

Here's the solution

For cell that you want minutes

=mid(f4,5,2)

For seconds

=right(f4,2)

[nigelk]

Well I guess this is one for the BA team.

The formulas given in the earlier link are correct and work all the time.

Looking at the attached screenprints in G5 & G6 I've got =len(F4), In the first print it equals 5, then 19,17, 9 then 8

You can see that it is the same race, just a few seconds between each shot. I'm assuming this is not intentional?

F5 & F6 are just formulas checking if F4 is text or number.

[doncht]

Thanks. I'll try this out and I'm almost positive that this is it already.