Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Decimal minutes to mm:ss format

127 views
Skip to first unread message

PSRumbagh

unread,
Jan 1, 2010, 7:18:01 PM1/1/10
to
I want to convert decimal minutes (e.g. 36.357) into mm:ss format. Does
excel 97 have a built in functin? If not, how do I create one.

Example: 36.357 minutes => 36:21.42

T. Valko

unread,
Jan 1, 2010, 7:43:26 PM1/1/10
to
Divide by 1440:

A1 = 36.357

=A1/1440

Format as m:s.00

--
Biff
Microsoft Excel MVP


"PSRumbagh" <PSRu...@discussions.microsoft.com> wrote in message
news:72A85324-5AC2-4E02...@microsoft.com...

T. Valko

unread,
Jan 1, 2010, 11:33:53 PM1/1/10
to
Try this format:

[m]:s.00

The brackets [ ] will keep the minutes from rolling over after 60.

--
Biff
Microsoft Excel MVP


"PSRumbagh" <PSRu...@discussions.microsoft.com> wrote in message

news:4ED1D64A-37B0-4C3C...@microsoft.com...
> Thanks.
>
> If time is greater than 59.99916667 minutes MUST use format cell as
> h:mm:ss
> after dividing by 1440.

>> .
>>


Modeste

unread,
Jan 2, 2010, 4:59:02 AM1/2/10
to
Bonsour® PSRumbagh avec ferveur ;o))) vous nous disiez :

> I want to convert decimal minutes (e.g. 36.357) into mm:ss format.
> Does excel 97 have a built in functin? If not, how do I create one.
>
> Example: 36.357 minutes => 36:21.42

literaly :
36.357 / "0:1"
result format [m]:ss

0 new messages