how to manipulate dates/times

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

Hi codeslizer,
thanks for the reply. The tricky bit here is the need to knock out any sundays and public holidays from the result.

workdays.intl is a good start (once you understand how it seems to work) but I have some formatting issues with how to actually use the results of the Minute function when the result is less than 10, I can tweak the display but not use it in a formula like a concatenate

jmac