# 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

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

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

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
>
>
>

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)

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)

>

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)

> >

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

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

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")

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

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)

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

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

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

1212.59 minutes is 20:12:35

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.

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

1212.59/1440
format cell as
[mm]:ss

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

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

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

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 .....

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

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

okzzz now i got it thanks for reply

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1