Monday, November 24, 2014

yogi_WorkAround For Computing ElapsedTime In Days Hours and Minutes From Specified StartTime

               Google Spreadsheet   Post  #1844
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Nov-24-2014
post by Matt Speth:
https://productforums.google.com/forum/#!msg/docs/JOLE6EQynW0/-8S0vR-5jJoJ
Formatting Help with Day and Time Durations
Hello.

I have a tally sheet and a chart that calc durations for some running races.  I couldn't get the information to format into a D HH:MM so I played with it in excel and then re-sent it to Sheets.

Sheets doesn't have (apparently) the format I'm looking for.  This is the Excel information descending a column...

0 d 01:41
0 d 02:45
0 d 02:45
0 d 04:25
0 d 13:08
0 d 14:20
0 d 16:26
0 d 21:03
1 d 03:47
1 d 07:45

And this is the Sheets interpretation (WRONG):

30 d 01:41
30 d 02:45
30 d 02:45
30 d 04:25
30 d 13:08
30 d 14:20
30 d 16:26
30 d 21:03
31 d 03:47
31 d 07:45

Again, both items are formatted to - D "d" HH:MM - but Sheets comes up with Calendar Days.  Any suggestions to get a duration?

Another issue is that I need all of the information - it can't be a text string because I need to chart the information once it's been collected.
--------------------------------------------------------------------------------
Let us first look at getting the Days Hours:Minutes right ... and then we can look at getting these as Numbers for plotting purposes