If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How to measure the distance between two lat and long points | A new kind of measurement | Running & Setting Up Queries | 6 | January 14th, 2005 04:45 PM |
How to convert a decimal number to a non-decimal number? | snickers22 | Worksheet Functions | 4 | January 13th, 2005 10:04 PM |
time - # of minutes = time | AdamB | General Discussion | 2 | October 20th, 2004 05:07 AM |
How can I convert degrees minutes seconds to decimal degrees | Heidi | Worksheet Functions | 1 | September 23rd, 2004 02:55 PM |
Convert Number to Time | Steved | Worksheet Functions | 8 | July 27th, 2004 10:53 AM |