Thanks in advance Problem..converting time format shown as 01:36.4 to 96.4 seconds Tony
T Tony Moffat Nov 14, 2004 #1 Thanks in advance Problem..converting time format shown as 01:36.4 to 96.4 seconds Tony
J JE McGimpsey Nov 14, 2004 #2 Time is stored in XL as fractional days. Therefore multiply by 24*60*60: =A1*86400
A Alan Nov 14, 2004 #3 Tony Moffat said: Thanks in advance Problem..converting time format shown as 01:36.4 to 96.4 seconds Tony Click to expand... 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.
Tony Moffat said: Thanks in advance Problem..converting time format shown as 01:36.4 to 96.4 seconds Tony Click to expand... 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.
