Hi,

I have 2 fields dateSubmit and dateComplete on which I need to calculate TAT in hours, submit and complete dates does not have any time restrictions [can be submitted/completed 24x7]. TAT should be calculated meeting the below criteria

1. Need to exclude weekends (Saturday and Sunday).
2. Down time if any (due to internet/software not working)

An ideal scenario would be as below.
dateSubmit dateComplete TAT
9/5/2014 15:36 9/8/2014 13:19 21:43
9/6/2014 10:06 9/8/2014 12:07 12:07
9/5/2014 12:46 9/8/2014 12:10 23:23


9/6/2014 13:01 9/8/2014 12:15 12:15
9/7/2014 13:46 9/7/2014 11:07 0:00
9/19/2014 9:55 9/21/2014 10:13 14:05
9/8/2014 9:57 9/10/2014 8:07 44:09

Downtime
From To
9/8/2014 15:57 9/10/2014 17:07

Can someone give me a quick formula to calculate this please?