Your formula won't work for 01:25 (try it!), but it would give a result of
85 if the G2 had contained 01.25 instead of 01:25.

For your text input of :01:25, you need =60*MID(G2,2,2)+RIGHT(G2,2) or
otherwise =RIGHT(G2,5)*24*60
--
David Biddulph

"Phredd" wrote in message
...
I have data that I export to Excel where the total time comes in as :mm:ss.
I need to convert that format into seconds. For example, my report shows
me
:01:25, I need to be able to show that at 85 seconds. I have a formula
that
will convert mm:ss to seconds which is =INT(G2)*60+((G2-INT(G2))*100)
where
G2 is 01:25 the result will be 85. but the report i have now comes with
an
extra :. I cannot seem to be able to automatically remove the : at the
begining of the expression or modify my formula above to account for the
extra :. I am sure this is pretty simple it is just beyone me though.
Any
help will be much appreciated!
Phredd