Minutes to seconds - how to convert?

[Tony Moffat]

Thanks in advance

Problem..converting time format shown as 01:36.4 to 96.4 seconds


Tony

 

[JE McGimpsey]

Time is stored in XL as fractional days. Therefore multiply by 24*60*60:

=A1*86400

 

[Alan]

Thanks in advance

Problem..converting time format shown as 01:36.4 to 96.4 seconds


Tony

If the cell *displaying* as 01:36.4 contains a value of
'0.00111574074074074' and is formatted as:

mm:ss.0

then just re-format as:

[ss].0

HTH,

Alan.