Yogi Anand, D.Eng, P.E. Google Spreadsheet Post #683 Aug 10, 2012 www.energyefficientbuild.com.
user kyesullivan said: (http://productforums.google.com/forum/#!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
user kyesullivan said: (http://productforums.google.com/forum/#!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,
Kyle
--------------------------------------------------------------------------------------------
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
No comments:
Post a Comment