Discussions
Read on for the latest updates including:
• Agenda Builder launch
• SuiteWorld On Air registration
• New NetSuite Prompt Studio Contest
• And more!
Check out this thread to learn more!
Calculate total hours
Hi,
Need some help with my workflow that calculate the total of hours.
I added 2 fields on the work order completion to add the Start and End time.
Additionally I add to fields that calulates the total of Hours and Total of Minutes.
Minutes is working fine (formula: MOD((({custbody_schutte_woc_endtime}-{custbody_schutte_woc_starttime})*1440), 60) )
On the other hand, something strange happens with the hours.
If i add in the 'Minutes' 30 or more the hour calculation will be +1
Expected Results: HOUR: 8 - MINUTES 31
Formulas that I tried:
- ROUND((({custbody_schutte_woc_endtime}-{custbody_schutte_woc_starttime})*24),0)