Can someone check the javascript code and see what can be done. I am struggling to add B2 time to the start time I think i need to convert B2 time to milliseconds and them sum with the start time to convert the sum value to end time and put that time in yyyy-MM-dd hh:mm:ss format on D2.My final idea is this...B2 cell is edited (with a duration on it)C2 cell is added a start date/time in a format yyyy-MM-dd hh:mm:ssD2 cell is added a end date/time in a format yyyy-MM-dd hh:mm:ss (sum C2 cell with B2 cell)B2 cell will be transformed in a countdown timer between D2 and C2 (think it will be easy putting here a formula like the time difference between D2 and C2)The spreadsheet link is this one: https://docs.google.com/spreadsheets/d/1aHTmsf6ySsd1UQCVMu5ykmW8AyPD1xVTq3Y9zjLlYC0/edit#gid=0At this moment i am trying to put the duration in milliseconds to sum with the C2 cell (not sure if this can be done in any other way)Note:At this time only the line 2 is working to make that changes automatically, but when the code is correct it will be intended to work in any lineThanks in advance
Countdown timer list
google spreadsheets