cell value
 

Hi, is there any way that I could change a cell value of 90 which represents
90 mins to read 1.30= 1 hour and 30 minutes, I get the 90 from mulitplying
1.5 by 60.

Thanks in advance,

Wildauk.

cell value
 

If 90 is in cell A1, then in another cell enter:

=A1/(24*60)

then format the new cell as Custom h.mm
--
Gary's Student


"wildauk" wrote:

Hi, is there any way that I could change a cell value of 90 which represents
90 mins to read 1.30= 1 hour and 30 minutes, I get the 90 from mulitplying
1.5 by 60.

Thanks in advance,

Wildauk.