How do I create a formula to turn 2.58 into 2.35

  • Thread starter Thread starter Janette Webster
  • Start date Start date
J

Janette Webster

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?
 
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
 
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 said:
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

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?
Click to expand...
Click to expand...
 
You're welcome, Janette - thanks for feeding back.

Just be wary of my earlier comments.

Pete

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 said:
That could become very confusing.
Click to expand...
You could use Excel's built-in time formatting, by using this:
Click to expand...
=155 / 60 / 24
Click to expand...
and applying a custom format to the cell of:
[h].mm
Click to expand...

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.
Click to expand...
Hope this helps.
Click to expand...

- Show quoted text -
Click to expand...
 
A formula approach is actually not too difficult:

=INT(A1/60)+MOD(A1/60,1)*0.6

where 155 is in A1
 
Back
Top