SImple but Impossible Calculation

Hi all,

I am trying to calculate the duration that it has taken from start to finish & display that result as in

Please Login or Register  to view this content.

The calulation should not take into the account weekends nor holidays that are manually listed.

I tried using Networking function but it doesn't like the time format so I am struggling to use a formula that can calculate both.

For example:

Date & Time start Date & Time Finish Time Taken What I would like the result to show
09/12/2014 09:30 12/12/2014 11:30 4 Days 0 Hours 00 Mins 4 Days 2 hours 0 minutes
09/12/2014 09:30 12/12/2014 08:30 4 Days 0 Hours 00 Mins 3 Days 23 hours 0 minutes
24/12/2014 08:00 28/12/2014 12:00 1 Days 0 Hours 00 Mins 1 Days 4 hours 15 minutes


Any help or advice please?

Hope this will solve your problem. Waiting for your feedback.

Date Diff.PNG

=NETWORKDAYS(A1,C1,)&" Days "&(HOUR(D1-B1))&" Hours "&MINUTE(D1-B1)&" Minutes "&SECOND(D1-B1)&" Seconds"
=NETWORKDAYS(A1,C1,)&" Days "&(HOUR(ROUND((D2-B2),0))&" Hours "&MINUTE(D2-B2)&" Minutes "&SECOND(D2-B2)&" Seconds")

Hi there,

Thanks everyone for the various solutions i had them previously but didnt calculate holidays.
Peoe Le Mokko's solution worked like a charm.

Thank u very much