This content has been marked as final. Show 5 replies
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?