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

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
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)
 
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
 
Back
Top