ExcelBanter - Time conversion

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Time conversion (https://www.excelbanter.com/excel-discussion-misc-queries/44862-time-conversion.html)

Dave

Time conversion

When i download imformation from the internet the time format is in mm:ss.00,
how can i convert that to ss.oo, ie: 1m58s.05 to 118.05 or 0m57s.15 to 57.15.
Any help would be welcomed

JE McGimpsey

Format/Cells/Number/Custom [ss].00

In article ,
"Dave" wrote:

When i download imformation from the internet the time format is in mm:ss.00,
how can i convert that to ss.oo, ie: 1m58s.05 to 118.05 or 0m57s.15 to 57.15.
Any help would be welcomed

All times are GMT +1. The time now is 11:26 PM.