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

[Guest]

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

 

[Guest]

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/categorylist_expand.asp?sid=5228306

 

[Bob Phillips]

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

--
HTH

Bob Phillips

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

mm:ss

 

[Guest]

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!

 

[JE McGimpsey]

One way:

A1: 1,59
A2: =A1/1440

format A2 as "[m]:ss"

 

[Guest]

Now I got it! )
Thank you!

One way:

A1: 1,59
A2: =A1/1440

format A2 as "[m]: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)

 

[Bob Phillips]

which is what I said

--
HTH

Bob Phillips

Now I got it! )
Thank you!

One way:

A1: 1,59
A2: =A1/1440

format A2 as "[m]: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)

 

[JE McGimpsey]

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

 

[Bob Phillips]

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