| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formulas
I am trying to convert minutes into hundreds...I need to show the following
1.15 as 1.25 1.30 as 1.50 1.45 as 1.75 Is there a formula for this conversion? Thanks, |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formulas
Nancy
with your time in A1 try =A1*1440/60 format as general Mike "Nancy" wrote: I am trying to convert minutes into hundreds...I need to show the following 1.15 as 1.25 1.30 as 1.50 1.45 as 1.75 Is there a formula for this conversion? Thanks, |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formulas
If the numbers really are 1.15 with decimal and not 1:15 with colon, use
=INT(A1)+MOD(A1,1)*100/60 If the values are real time (1:15) use =A1*24 and format as General or Number -- Bernard Liengme Microsoft Excel MVP people.stfx.ca/bliengme email address: remove uppercase characters "Nancy" wrote in message ... I am trying to convert minutes into hundreds...I need to show the following 1.15 as 1.25 1.30 as 1.50 1.45 as 1.75 Is there a formula for this conversion? Thanks, |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| CELLS NOT CALC FORMULAS - VALUES STAY SME FORMULAS CORRECT?? HELP | Excel Worksheet Functions | |||
| lookup formulas dependent upon lookup formulas | Excel Worksheet Functions | |||
| automatically copy formulas down columns or copy formulas all the | Excel Worksheet Functions | |||
| Formulas not evaluated, Formulas treated as strings | Excel Discussion (Misc queries) | |||
| formulas for changing formulas? | Excel Discussion (Misc queries) | |||
Linear Mode
