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