This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

I have a Freeform Text Field (00:15:10), that I need to convert back to HH:MM:SS (or even a decimal) so that I can calculate the Average in a Saved Search. Any Formula Suggestions?

Hi Kevin, have a look at the <https://www.techonthenet.com/oracle/functions/to_date.php|TO_DATE Function> (potentially, but not sure if supported, also <https://www.techonthenet.com/oracle/functions/to_timestamp.php|TO_TIMESTAMP>/<https://www.techonthenet.com/oracle/functions/to_timestamp_tz.php|TO_TIMESTAMP_TZ> functions)