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?