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)
- ({custbody_schutte_woc_endtime}-{custbody_schutte_woc_starttime})*24
All with the same behavior that the total number of hours is rounded up.
Formula that has no result:
{custbody_schutte_woc_endtime}-{custbody_schutte_woc_starttime}
Does anyone know what I'm doing wrong and why the hour is rounded up?
Any help is welcom!
Thanks in advanced.
Regards Toanne