You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"Bob" wrote in message
...
Thanks this works like a charm.. Bob

"T. Valko" wrote:

Try this:

=ROUND(A1/60*1440,2)

Format as General or Number

--
Biff
Microsoft Excel MVP


"Bob" wrote in message
...
Hello, I am copying data from a table in a webpage and am having
difficulty
in converting the minutes and seconds. Example

2836:24:00 is really 2836 minutes 24 seconds and who knows what the 00
is.

I have tried [mm]:ss and that returns the real minutes as if
calcualated
in
hours.

Another example is 16:10 which is 16 minutes 10 seconds.

I need to convert these to example to the folowing format and am lost
as
to
how to do it..

2836.4 Minutes

and
16.17 minutes

I welcom all advise and help..

Thanks Bob