convert decimal number to time : convert 1,59 (minutes, dec) to m

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" <agenda9533@discussions.microsoft.com> wrote in message
news:6D912381-D89A-4231-8772-3536DF081BDB@microsoft.com...
> 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" <agenda9533@discussions.microsoft.com> wrote in message
> news:6D912381-D89A-4231-8772-3536DF081BDB@microsoft.com...
> > 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-F7CE451EB5DF@microsoft.com>,
"agenda9533" <agenda9533@discussions.microsoft.com> 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-F7CE451EB5DF@microsoft.com>,
> "agenda9533" <agenda9533@discussions.microsoft.com> 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" <agenda9533@discussions.microsoft.com> wrote in message
news:69541286-1858-4957-8628-348A6AFE38D8@microsoft.com...
> 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-F7CE451EB5DF@microsoft.com>,
> > "agenda9533" <agenda9533@discussions.microsoft.com> 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)
> >

USE THIS FORMULA
Put the 1.59 in A1 Cell and paste this in any other cell it will give u result in [mm]:ss


=TEXT(LEFT(TEXT(A1,"0000.00"),2)&":"&MID(TEXT(A1,"0000.00"),3,2)&":"&ROUND(RIGHT(TEXT(A1,"0000.00"),2)*6/10,0),"[mm]:ss")

Sir it will converted all hours into minutes and seconds as per que. ([mm]:ss)

Then Please tell me what we do if value is 1212.59 instead of 1.59

yes thats i knw bt wht was the formula to calculate that in excel and 2nd i need in minutes and seconds only not in hrs.

Originally Posted by martindwilson

1212.59/1440
format cell as
[mm]:ss

that will give 1212:35 but ans should be 732:35 (12*60+12)=732 minutes

1st how it is 20:12:35 it should b 12:12:35

2nd what else if i needed that result in Minutes and seconds only

okzzz i agree with u
please tell me why we multiply or divide with 1440 what is this trick?? , i cannot understand this trick .....

okzzz now i got it thanks for reply