Formula minutes and seconds
 

How do I change the following:
The cell reads: 14:42:0 for minutes and seconds.
I need to convert cell to 14.7
--
John

Formula minutes and seconds
 

Are you sure this is not hours:minutes:seconds? Usually you would have
14:42.0 if this stood for 14 minutes and 42 seconds (with no tenths of
a second), but the way you have typed it it looks like 14 hours and 42
minutes.

If it does stand for hh:mm:ss and you want the number of hours, then
just multiply it by 24 and format the cell as a number with 1 decimal
place. If it stands for mm:ss:tt with hours not displayed, then you
will need to multiply by 24 and by 60 to convert it to decimal
minutes.

Hope this helps.

Pete

On Nov 21, 11:01 pm, John wrote:
How do I change the following:
The cell reads: 14:42:0 for minutes and seconds.
I need to convert cell to 14.7
--
John

Formula minutes and seconds
 

Hi,

Try

=A1*60*24

Regards!
Jean-Guy

"John" wrote:

How do I change the following:
The cell reads: 14:42:0 for minutes and seconds.
I need to convert cell to 14.7
--
John