Friday, August 24, 2012

yogi_Enter Time In Minutes Seconds And Fractions of Seconds In Google Spreadsheet

Yogi Anand, D.Eng, P.E.       Google Spreadsheet    Post  #714   Aug 24, 2012     www.energyefficientbuild.com.

user AMPC said: (http://productforums.google.com/forum/?zx=frqi4n9v2tm8#!category-topic/docs/spreadsheets/TUN-0q62B4Q)
TIME: minutes, seconds, hundreds
How do you input time as minutes, seconds, hundreds rather than hours .....
-------------------------------------------------------------------------------

As of now (Aug 2012) there is no direct way to enter time in minutes, seconds, and fractions of seconds in Google spreadsheet -- in the following I present a workaround solution