converting time

  • Thread starter Thread starter serene
  • Start date Start date
S

serene

Would anyone know a formula that will allow me to convert
time hh:mm:ss (3:03:38) into mm (183.6)
 
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
_ _
^¢¯^
--
 
Back
Top