Hello,

I am trying (in vain I must admit) to calculate the net duration between two date/time cells

I have two working cells,
the first is the raw difference between two original date/time cells and shows me 6/01/1900 20:36 which equates to 6 days, 20 hours and 36 seconds

the second cell in the number of workdays (using the networkdays.intl function) between the two original dates which in this case is 4 days

I can see that I need an answer that is = 96 ( 4 * 24) plus the 20:36 from the first working cell or 116.36 hours

All the bits I need I can see but not manipulate

any help appreciated

Jmac1947