Converting to minutes and seconds

Hi there

Does anyone know how to convert a number into minutes and seconds in the
following format - mm:ss

Many thanks

To expand - I would like to do this when the number is the result of a MAX
formula. I have tried using the custom mm:ss format but this just gives me
the result 00:00 for some reason.

"JaB" wrote:

> Hi there
>
> Does anyone know how to convert a number into minutes and seconds in the
> following format - mm:ss
>
> Many thanks

In which units is the number expressed (seconds, minutes, hours, ... ) ?

--
AP

"JaB" <JaB@discussions.microsoft.com> a écrit dans le message de news:
28F44E58-7A5E-4BE6-B5BF-A91C04AC9930@microsoft.com...
> To expand - I would like to do this when the number is the result of a MAX
> formula. I have tried using the custom mm:ss format but this just gives
> me
> the result 00:00 for some reason.
>
> "JaB" wrote:
>
>> Hi there
>>
>> Does anyone know how to convert a number into minutes and seconds in the
>> following format - mm:ss
>>
>> Many thanks

At the moment, the figure expressed is in seconds but displayed just as a
general number.

"Ardus Petus" wrote:

> In which units is the number expressed (seconds, minutes, hours, ... ) ?
>
> --
> AP
>
> "JaB" <JaB@discussions.microsoft.com> a écrit dans le message de news:
> 28F44E58-7A5E-4BE6-B5BF-A91C04AC9930@microsoft.com...
> > To expand - I would like to do this when the number is the result of a MAX
> > formula. I have tried using the custom mm:ss format but this just gives
> > me
> > the result 00:00 for some reason.
> >
> > "JaB" wrote:
> >
> >> Hi there
> >>
> >> Does anyone know how to convert a number into minutes and seconds in the
> >> following format - mm:ss
> >>
> >> Many thanks
>
>
>

XL stores times as fractional days, so if you want a true XL time,
you'll need to divide by 24*60*60:

A1: 23
A2: =A1/86400 ===> 0:00:23

In article <1BC13971-3AA3-45DC-81E1-70F1375DE899@microsoft.com>,
JaB <JaB@discussions.microsoft.com> wrote:

> At the moment, the figure expressed is in seconds but displayed just as a
> general number.

Thanks Je,

You saved me some typing.

Cheers
--
AP

"JE McGimpsey" <jemcgimpsey@mvps.org> a écrit dans le message de news:
jemcgimpsey-773B7F.07050602052006@msnews.microsoft.com...
> XL stores times as fractional days, so if you want a true XL time,
> you'll need to divide by 24*60*60:
>
> A1: 23
> A2: =A1/86400 ===> 0:00:23
>
> In article <1BC13971-3AA3-45DC-81E1-70F1375DE899@microsoft.com>,
> JaB <JaB@discussions.microsoft.com> wrote:
>
>> At the moment, the figure expressed is in seconds but displayed just as a
>> general number.