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?

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?

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?

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 -

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?