Convert Times to Decimals

[mg]

For example I have a time of 0:04:23 which is using the
format of h:mm:ss and I want to convert this to the
decimal equivalent of 4.38.
Any ideas would be most appreciated.

 

[Frank Kabel]

Hi
use
=A1*24*60
and format this cell as number

 

[Vasant Nanavati]

Multiply it by 1440 and format it as a number with 2 decimal points.

 

[MG]

Thanks, worked well.

-----Original Message-----
Hi
use
=A1*24*60
and format this cell as number

--
Regards
Frank Kabel
Frankfurt, Germany


.

 

[MG]

Thanks, worked well.

-----Original Message-----
Multiply it by 1440 and format it as a number with 2 decimal points.

--

Vasant




.