Hi all,
I am trying to calculate the duration that it has taken from start to finish & display that result as inThe calulation should not take into the account weekends nor holidays that are manually listed.Please Login or Register to view this content.
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?
Bookmarks