How to convert decimal number to time : convert 1,59 (minutes, dec) to mm:ss

If the latter part of the number is decimal, then 59% of 60 minutes would be
the answer

1.59 minutes = 1:34 (mm:ss)

http://www.ingenio.com/categories/ca...sp?sid=5228306

"agenda9533" wrote:

> How to convert decimal number to time : convert 1,59 (minutes, dec) to mm:ss

Divide it by 24 if it is hours, or by 1440 if it is minutes

--
HTH

Bob Phillips

"agenda9533" <(E-Mail Removed)> wrote in message
news:6D912381-D89A-4231-8772-(E-Mail Removed)...
> How to convert decimal number to time : convert 1,59 (minutes, dec) to
mm:ss

Problem is - I know how to calculate this mannualy. But I need a function
that converts a decimal number of minutes ( for example , 1.59 ) to a time
format mm:ss (1:48)

Thank you for all your answers!

"Bob Phillips" wrote:

> Divide it by 24 if it is hours, or by 1440 if it is minutes
>
> --
> HTH
>
> Bob Phillips
>
> "agenda9533" <(E-Mail Removed)> wrote in message
> news:6D912381-D89A-4231-8772-(E-Mail Removed)...
> > How to convert decimal number to time : convert 1,59 (minutes, dec) to
> mm:ss
>
>
>

One way:

A1: 1,59
A2: =A1/1440

format A2 as "[m]:ss"


In article <D7745D58-E8CE-437B-8B53-(E-Mail Removed)>,
"agenda9533" <(E-Mail Removed)> wrote:

> Problem is - I know how to calculate this mannualy. But I need a function
> that converts a decimal number of minutes ( for example , 1.59 ) to a time
> format mm:ss (1:48)

Now I got it! :-))
Thank you!

"JE McGimpsey" wrote:

> One way:
>
> A1: 1,59
> A2: =A1/1440
>
> format A2 as "[m]:ss"
>
>
> In article <D7745D58-E8CE-437B-8B53-(E-Mail Removed)>,
> "agenda9533" <(E-Mail Removed)> wrote:
>
> > Problem is - I know how to calculate this mannualy. But I need a function
> > that converts a decimal number of minutes ( for example , 1.59 ) to a time
> > format mm:ss (1:48)
>

which is what I said

--
HTH

Bob Phillips

"agenda9533" <(E-Mail Removed)> wrote in message
news:69541286-1858-4957-8628-(E-Mail Removed)...
> Now I got it! :-))
> Thank you!
>
> "JE McGimpsey" wrote:
>
> > One way:
> >
> > A1: 1,59
> > A2: =A1/1440
> >
> > format A2 as "[m]:ss"
> >
> >
> > In article <D7745D58-E8CE-437B-8B53-(E-Mail Removed)>,
> > "agenda9533" <(E-Mail Removed)> wrote:
> >
> > > Problem is - I know how to calculate this mannualy. But I need a
function
> > > that converts a decimal number of minutes ( for example , 1.59 ) to a
time
> > > format mm:ss (1:48)
> >

He probably got a decimal number and didn't know what to do with it.
Just dividing doesn't format it as time.

In article <eBkjiJy$(E-Mail Removed)>,
"Bob Phillips" <(E-Mail Removed)> wrote:

> which is what I said

If he knew how to calculate it manually, it would have helped if he had
asked how he could put into a cell formula, rather than how to convert it.

Bob

"JE McGimpsey" <(E-Mail Removed)> wrote in message
news:jemcgimpsey-(E-Mail Removed)...
> He probably got a decimal number and didn't know what to do with it.
> Just dividing doesn't format it as time.
>
> In article <eBkjiJy$(E-Mail Removed)>,
> "Bob Phillips" <(E-Mail Removed)> wrote:
>
> > which is what I said