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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Decimal minutes to mm:ss format 4
Compute MPH from Distance and Minutes:Seconds? 1
Formating seconds into mm:ss 4
Excel Convert Datetime Stamp to HH and MM Worked 7
How do I convert time as text 'mm:ss to time value in Excel 5
adding minutes and seconds correctly 8
Converting Hours into Days 7
Converting :mm:ss to ss 8

Back
Top