Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
agenda9533
 
Posts: n/a
Default 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   Report Post  
galimi
 
Posts: n/a
Default

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

  #3   Report Post  
Bob Phillips
 
Posts: n/a
Default

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

--
HTH

Bob Phillips

"agenda9533" wrote in message
...
How to convert decimal number to time : convert 1,59 (minutes, dec) to

mm:ss


  #4   Report Post  
agenda9533
 
Posts: n/a
Default

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" wrote in message
...
How to convert decimal number to time : convert 1,59 (minutes, dec) to

mm:ss



  #5   Report Post  
JE McGimpsey
 
Posts: n/a
Default

One way:

A1: 1,59
A2: =A1/1440

format A2 as "[m]:ss"


In article ,
"agenda9533" 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   Report Post  
agenda9533
 
Posts: n/a
Default

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

"JE McGimpsey" wrote:

One way:

A1: 1,59
A2: =A1/1440

format A2 as "[m]:ss"


In article ,
"agenda9533" 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   Report Post  
Bob Phillips
 
Posts: n/a
Default

which is what I said

--
HTH

Bob Phillips

"agenda9533" wrote in message
...
Now I got it! :-))
Thank you!

"JE McGimpsey" wrote:

One way:

A1: 1,59
A2: =A1/1440

format A2 as "[m]:ss"


In article ,
"agenda9533" 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   Report Post  
JE McGimpsey
 
Posts: n/a
Default

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 ,
"Bob Phillips" wrote:

which is what I said

  #9   Report Post  
Bob Phillips
 
Posts: n/a
Default

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" wrote in message
...
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 ,
"Bob Phillips" wrote:

which is what I said



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Adding minutes to time Randberger Excel Discussion (Misc queries) 4 January 19th 05 09:49 PM
convert scientific notation to a number Peter Excel Discussion (Misc queries) 1 January 4th 05 08:08 PM
How do I convert times from hours to minutes? kkrebs Excel Discussion (Misc queries) 5 December 30th 04 07:13 PM
Convert data of cells to any type: Number, Date&Time, Text Kevin Excel Discussion (Misc queries) 0 December 30th 04 07:55 AM
Convert Time...!convert tenths of a second Pape Excel Discussion (Misc queries) 2 December 16th 04 11:17 AM


All times are GMT +1. The time now is 05:26 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"