Friday, August 10, 2012

yogi_Convert A String Of Times In Hours Minutes And Seconds Into Minutes And Decimals Of Minutes

Yogi Anand, D.Eng, P.E.       Google Spreadsheet    Post  #683   Aug 10, 2012

user kyesullivan said: (!category-topic/docs/spreadsheets/weD03160DcI%5B1-25%5D)
Time format conversion
Hi, I want to manipulate data that is in the form of "5m 13s" (the part in the quotations). It is a duration. I want to be able to convert to a decimal number (so 5m 13s = 5.22 minutes). Is that possible? What kind of formula should I employ? Thanks,

following is a solution to a bit more generalized problem where the time string may consist of any of hours, minutes, and seconds, and in any order as shown in the illustration