Hello

I have a custom function in Zoho Sheet developed to convert a date time from one time zone to another.

The custom function takes date and time columns and then using subHour( ) converts the time to PST time.

However, though the custom function works, some of the values in the column suddenly shows #EVAL! error.

At first After dragging the handle to apply the function across the column, sheet will stop responding and show that it is running but then returns the error #EVAL! 

However, after some time, I managed to apply across about 2,250 records. But the second issue which is troubling is after applying the function on the column, when I return to the sheet after some time, some of the columns, change and starts showing error #EVAL! again.

Please see the screenshot below.