I've looked around and have seen a lot of people ask this same question, but all of the answers I get are either confusing or don't seem to fit with my situation. Here's a dummy sheet (first time, just let me know if it needs anything else added): https://docs.google.com/spreadsheets/d/1Lb7RQy1mgFlMsxH_mayGs8sN8hkj5ALt6xGorzZnaIo/edit?usp=sharing The function that I created via script editing is called TEST2 which just indexes the input. The problem is, the input is a range of data where that data is time entries. So whenever I use TEST2 on the time column, the index it returns should be 0:00:00, but it's actually 12/30/1899. Do I need to handle this via the custom function in the script, or is there another way?
The "problem" occurs because the cell format of the cell containing the custom function.
One way to solve this is to change the format from date to duration.