Discussions

Check out Oracle NetSuite upcoming events and conferences here
Now is the time to ask your NetSuite-savvy friends and colleagues to join the NetSuite Support Community! Refer now!
RUN, DON’T WALK...Registration for #SuiteWorld 2022 is officially OPEN! This special early bird price won’t last long, so make sure you don’t miss out: https://lnkd.in/gGRN78A3
YOUR VOICE MATTERS! VOTE FOR OUR NEXT WEBINAR TOPIC NOW.
Click on this link for the poll.

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)

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!

Leaderboard

This Week's Leaders

This Month's Leaders

All Time Leaders