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

1. ## 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  Register To Reply

2. ## RE: convert decimal number to time : convert 1,59 (minutes, dec) to m

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

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  Register To Reply

3. ## Re: convert decimal number to time : convert 1,59 (minutes, dec) to m

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  Register To Reply

4. ## Re: convert decimal number to time : convert 1,59 (minutes, dec)

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)

"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
>
>
>  Register To Reply

5. ## Re: convert decimal number to time : convert 1,59 (minutes, dec)

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)  Register To Reply

6. ## Re: convert decimal number to time : convert 1,59 (minutes, dec)

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)

>  Register To Reply

7. ## Re: convert decimal number to time : convert 1,59 (minutes, dec)

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)

> >  Register To Reply

8. ## Re: convert decimal number to time : convert 1,59 (minutes, dec)

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\$EHA.1604@TK2MSFTNGP12.phx.gbl>,
"Bob Phillips" <phillips@tiscali.co.uk> wrote:

> which is what I said  Register To Reply

9. ## Re: convert decimal number to time : convert 1,59 (minutes, dec)

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" <jemcgimpsey@mvps.org> wrote in message
news:jemcgimpsey-37A3AE.12311120012005@msnews.microsoft.com...
> 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\$EHA.1604@TK2MSFTNGP12.phx.gbl>,
> "Bob Phillips" <phillips@tiscali.co.uk> wrote:
>
> > which is what I said  Register To Reply

10. ## Re: convert decimal number to time : convert 1,59 (minutes, dec) to m

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")  Register To Reply

11. ## Re: convert decimal number to time : convert 1,59 (minutes, dec) to m

8 year old thread and that formula gives wrong results if the decimal part is longer than 2 digits  Register To Reply

12. ## Re: convert decimal number to time : convert 1,59 (minutes, dec) to m

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

13. ## Re: convert decimal number to time : convert 1,59 (minutes, dec) to m

you divide decimal mins by 1440 that's it nothing else needed  Register To Reply

14. ## Re: convert decimal number to time : convert 1,59 (minutes, dec) to m

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

15. ## Re: convert decimal number to time : convert 1,59 (minutes, dec) to m

1212.59 minutes is 20:12:35  Register To Reply

16. ## Re: convert decimal number to time : convert 1,59 (minutes, dec) to m

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.  Register To Reply

17. ## Re: convert decimal number to time : convert 1,59 (minutes, dec) to m

1212.59/1440
format cell as
[mm]:ss  Register To Reply

18. ## Re: convert decimal number to time : convert 1,59 (minutes, dec) to m

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  Register To Reply

19. ## Re: convert decimal number to time : convert 1,59 (minutes, dec) to m 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  Register To Reply

20. ## Re: convert decimal number to time : convert 1,59 (minutes, dec) to m

no thats not the question here, the question is decimal minutes to seconds NOT 1212.59 where 1212 is representing 12 hrs 12 minutes
1212 mins is 20.2 hours read the question by the original
poster
see my response here where you also posted
http://www.excelforum.com/excel-gene...2-17-30-a.html  Register To Reply

21. ## Re: convert decimal number to time : convert 1,59 (minutes, dec) to m

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

22. ## Re: convert decimal number to time : convert 1,59 (minutes, dec) to m

time codes are fractions of 24 hours 1 hour is 1/24 of a day 1 minute is 1/(24*60) of a day or 1/1440
so to convert 1 minute(decimal) to the time code as a fraction of a day 1 minute /1440 =0.000694444
when
0.000694444
is formatted as time hh:mm:ss
it gives 00:01:00  Register To Reply

23. ## Re: convert decimal number to time : convert 1,59 (minutes, dec) to m

okzzz now i got it thanks for reply   Register To Reply