Converting minutes, seconds and tenths of seconds into seconds

**Skybeau** · 01-18-2010, 04:16 AM

Hi guys,

I've searched the net and can't find an answer to my problem.

Basically I want to change 1 minute 24 seconds and 5 tenths into a seconds number.

So basically it would come out as 84.50 seconds.

Can anyone help me ?

**arthurbr** · 01-18-2010, 04:24 AM

Hi, under which format does the data appear?

**DonkeyOte** · 01-18-2010, 04:25 AM

is "1 minute 24 seconds and 5 tenths" an actual time value (eg 0:01:02.5) or is it a text string ?

if the former... it's a simple case of:

Please Login or Register  to view this content.

where A1 holds original time value...

if however it is a text string then we'd need to know more regards other (potential) variants of the string - could you perhaps post an example ?

**Skybeau** · 01-18-2010, 04:27 AM

Donkey !!!!!!

You are the MAN !!!!!!!!!!!!!!!!!!!!!!!

Arthur, you are also the man cos you took the time out to help me !!!!!

How do I add the sticky thing to make the topic solved ?

**DonkeyOte** · 01-18-2010, 04:29 AM

Standard guff:

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save