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)



"Capss" <(E-Mail Removed)> wrote in message
news:7E9C2709-B7C7-4A0C-B224-(E-Mail Removed)...
> 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.
>

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


In article <7E9C2709-B7C7-4A0C-B224-(E-Mail Removed)>,
Capss <(E-Mail Removed)> wrote:

> 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.