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

Use TO_CHAR AND THEN TO_NUMBER and use output results should be float

Thakn you <@U61TENRBJ> I tried this but couldnt get it to work TO_CHAR(TO_NUMBER({duration}))

I also tried TO_NUMBER(TO_CHAR({duration}))  where duration is datetime, any feedback on why this isn't working, I'm fairly new at SQL

<@U01511V85J7> TO_NUMBER(TO_CHAR({duration}, 'hh')) use this since you're trying to extract only hours right

then have it TO_NUMBER(TO_CHAR({duration}, 'hh'))*({rate})

idealy it be hours with minutes so I was going to do the value * 24, I do this in excel whenever I want to convert a time to a number

probably more difficult than it should be lol

you should take hour's and convert into minutes like 2*60 and take minutes as well 120+15= 135 minutes something likesss

Also, rate as well convert from dollar equal to minutes 120 rate/ 60 min then use it per min.

it's all up to you however you wanna get it over