Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
abul_mohsin
Starting Member
21 Posts |
 Posted - 2013-01-17 : 04:50:13
|
| I need to calculate the business hours(08:00:00 - 18:00:00) between two dates by ignoring the weakend that is friday,Earlist reply is highly appriciated.Sample date in the table SubmitDate SubmitTime ReplyDate ReplyTime08/01/2013 17:48:03 12/01/2013 08:20:29need the difference between these two dates and time by ignoring the weakend Friday.Thanks & Best Regard'sAbul Mohsin |
|
|
|
|
|
calculate the business hours between two dates