GAS-TimeTracker
GAS-TimeTracker copied to clipboard
Duration format?
Hello! This is a very handy script! I got a strange format though for the line 97 and 114 in Code.js. You have it as sheet.getRange(lineN,4).setNumberFormat("%hn"); and sheet.getRange('E:E').setNumberFormat('%hn');respectively. I am not sure what the %hn format used to be, but it does not give me a proper duration. I was able to fix this by using '[h]:mm' instead. This also (I think) is better than using the 'HH:mm' format, since this format will have issues with 24 hour clock. For example, if I have 25 hours set, and I do something for one hour. The Column E will report 00:00 instead of 24:00. Maybe it is just my settings, but using the '[h]:mm' seemed to fix this.