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
Let us first look at getting the Days Hours:Minutes right ... and then we can look at getting these as Numbers for plotting purposes
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
No comments:
Post a Comment