5 Replies Latest reply: Apr 9, 2014 10:58 AM by Amay Patil RSS

    NetworkDays Expression

    Sara Titmuss

      Hello,

       

      I am looking to do an expression similar to a networkdays one,  however I do not want the days I want to show the number of hours.

       

      My dates are set up as follows:

       

      ACTIVITY_DATE = DD/MON/YYYY hh:mm

      ACTIVITY_END = DD/MON/YYYY hh:mm

       

      So when using the normal networkdays expressions (=NETWORKDAYS(ACTIVITY_DATE,ACTIVITY_END))  I received 0 as the activity has happened on the same day.  Is there a way of calculating the hours?

       

      Thank you.