How can I convert seconds into minutes? (mm:ss -> min.x)

[Guest]

Hello,

I have several telephone numbers from different providers.
The statistics from most of all are in minutes (eg: 137.83)

But one of them is in mm:ss format.

I need to convert mm:ss to min.x.
As an example:
The total is 630:15
I need to convert this to 630.25

Or 155:50 to 155.83

Many thanks in advance.

 

[Bob Phillips]

Just multiply by 24 and format as 0.00

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[JE McGimpsey]

XL stores times as fractional days, so multiply the time by 24 hours by
60 minutes:

=A1 * 24 * 60

or equivalently

=A1 * 1440

and Format as General or a Number format