NetworkDays Expression

[#1]

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.

[MK_QSL]

=TIME(ACTIVITY_END , ACTIVITY_DATE, 'hh:mm:ss')

[#3]

Does't seem to like the , before 'hh:mm:ss' and comes up with an error. 

[MK_QSL]

Try this...

=TIME(Timestamp#(ACTIVITY_END,'DD/MMM/YYYY hh:mm') - Timestamp#(ACTIVITY_DATE,'DD/MMM/YYYY hh:mm'),'hh:mm')

[#5]

Hi,

You can try

=NetWorkDays(ACTIVITY_DATE, ACTIVITY_END) + Frac(Time(ACTIVITY_END-ACTIVITY_DATE, 'hh:mm'))

[#6]

Hi

Use Interval() function.

Interval(ACTIVITY_END-ACTIVITY_DATE, 'D hh:mm')