| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I create a formula to turn 2.58 into 2.35
I have a formula to turn minutes in to hours and a decimal ex. 155/60=2.58.
However, I need to turn the .58 into .35. Does anyone know of a formula that might make this possiable? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I create a formula to turn 2.58 into 2.35
That could become very confusing.
You could use Excel's built-in time formatting, by using this: =155 / 60 / 24 and applying a custom format to the cell of: [h].mm which will show 2.35, but you should be aware that this is not really the number 2.35 (the underlying value is 0.107639), so you should not use it directly in any arithmetic. Hope this helps. Pete On Jul 31, 4:28*pm, Janette Webster <Janette wrote: I have a formula to turn minutes in to hours and a decimal ex. 155/60=2..58. However, I need to turn the .58 into .35. Does anyone know of a formula that might make this possiable? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I create a formula to turn 2.58 into 2.35
Thank you so much. I think that is just what we needed. I tried a different
number and it work also.. You are awesome!!!! Thanks again. "Pete_UK" wrote: That could become very confusing. You could use Excel's built-in time formatting, by using this: =155 / 60 / 24 and applying a custom format to the cell of: [h].mm which will show 2.35, but you should be aware that this is not really the number 2.35 (the underlying value is 0.107639), so you should not use it directly in any arithmetic. Hope this helps. Pete On Jul 31, 4:28 pm, Janette Webster <Janette wrote: I have a formula to turn minutes in to hours and a decimal ex. 155/60=2..58. However, I need to turn the .58 into .35. Does anyone know of a formula that might make this possiable? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I create a formula to turn 2.58 into 2.35
You're welcome, Janette - thanks for feeding back.
Just be wary of my earlier comments. Pete On Jul 31, 5:00*pm, Janette Webster wrote: Thank you so much. I think that is just what we needed. I tried a different number and it work also.. You are awesome!!!! Thanks again. "Pete_UK" wrote: That could become very confusing. You could use Excel's built-in time formatting, by using this: =155 / 60 / 24 and applying a custom format to the cell of: [h].mm which will show 2.35, but you should be aware that this is not really the number 2.35 (the underlying value is 0.107639), so you should not use it directly in any arithmetic. Hope this helps. Pete On Jul 31, 4:28 pm, Janette Webster <Janette wrote: I have a formula to turn minutes in to hours and a decimal ex. 155/60=2..58. However, I need to turn the .58 into .35. Does anyone know of a formula that might make this possiable?- Hide quoted text - - Show quoted text - |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I create a formula to turn 2.58 into 2.35
A formula approach is actually not too difficult:
=INT(A1/60)+MOD(A1/60,1)*0.6 where 155 is in A1 -- If this helps, please click the Yes button. Cheers, Shane Devenshire "Janette Webster" wrote: I have a formula to turn minutes in to hours and a decimal ex. 155/60=2.58. However, I need to turn the .58 into .35. Does anyone know of a formula that might make this possiable? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| can you create a spot in Excel which you can turn on and off by c. | Excel Discussion (Misc queries) | |||
| Want formula to turn to value by itself | Excel Discussion (Misc queries) | |||
| how to create a if statement, if true turn colour | Excel Worksheet Functions | |||
| Turn Off Formula ? | New Users to Excel | |||
| My formula bar disappeared. How do I turn it on? | Excel Discussion (Misc queries) | |||
Hybrid Mode
