TAT minutes including weekend

[jodipy]

Hi all,

This is my first post. I've search and read some post but couldn't get what I was looking for.

[TABLE="class: grid, width: 500, align: center"]
<tbody>[TR]
[TD]Received time
[/TD]
[TD]Complete time
[/TD]
[TD]TAT (mins)
[/TD]
[TD]Business hours (include weekends/public holidays)
[/TD]
[/TR]
[TR]
[TD]21/11/2015 11:00PM
[/TD]
[TD]22/11/2015 10:00AM
[/TD]
[TD]60
[/TD]
[TD]9:00AM - 9:00PM
[/TD]
[/TR]
[TR]
[TD]22/11/2015 11:00AM
[/TD]
[TD]22/11/2015 11:45AM
[/TD]
[TD]45
[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

Above is an example of my setup. I've tried to use networkdays to calculate but the result is wrong.
Anyone can help?

 

[jodipy]

DRSteele: I've tried to change a little on the formula but still unable to get the data right. Can you please advise again?

 

[DRSteele]

Which operating system and which version of Excel are you using?

 

[jodipy]

Hi! I'm using Windows 7 and Excel 2010