converting time

[serene]

Would anyone know a formula that will allow me to convert
time hh:mm:ss (3:03:38) into mm (183.6)

 

[Biff]

Just multiply it by 1440 and format as General.

Biff

 

[Soo Cheon Jheong]

Hi,

-----------A-------------B------------
1 Time(HH:MM:SS) Time(MM)
2 3:03:38 ?
3
--------------------------------------

Enter a formula in B2:

=A2*24*60


--
Regards,
Soo Cheon Jheong
_ _
^¢¯^
--