GAS-TimeTracker icon indicating copy to clipboard operation
GAS-TimeTracker copied to clipboard

Duration format?

Open fraguada opened this issue 9 years ago • 0 comments

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.

fraguada avatar Jan 11 '17 17:01 fraguada