How do I create a formula to turn 2.58 into 2.35

[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?

 

[Pete_UK]

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

 

[Janette Webster]

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.

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?

 

[Pete_UK]

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.

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.

- Show quoted text -

 

[Shane Devenshire]

A formula approach is actually not too difficult:

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

where 155 is in A1