Hello everyone,
Some things are either terribly difficult in Excel (or it's me ;-)).
Can't seem to convert a simple "01:04.6" into a decimal value in seconds. The units are in "minutes:seconds", so this should read 01 minute, 4.6 seconds and I wish to convert it to 64.6 seconds. It tried different formulae and format settings but the "01" for example is always wrongly taken as hours. Surely there must be a simple formula to give me the "64.6" as answer. Ideas anyone?
Best regards,
Excel_Arate
Bookmarks