New answers tagged javascript
1
Google Apps Script / JavaScript doesn't include a "native" way to handle durations but you could use a library like moment.js to add several methods to handle them but this could imply a steeped learning curve. A simpler solution is to read the duration from the spreadsheet as "displayed value" by using getDisplayValue instead of the "inherent value" got ...
2
Working with date, time and specifically duration is a pain in JavaScript, and Google Sheets does not make it much easier.
A JavaScript Date object (which is really a datetime object) is not suited for working with durations. A datetime is a lot more complex than it seems at first.
So when you ask
Where did the "days" part of the duration go?
... ...
0
There is an error on elseif. The correct syntax is else if
Top 50 recent answers are included
