<div>
Hi,<br />
<br />
I do have some SQL that calculates the working hours between 2 dates but it doesn't cater for the lunch break, however this shouldn't be hard to add in. The stored procedure also relies on a SQL function that finds out if each day is a working day. This function further relies on a table containing non-working days, like Good Friday etc. I can post it if you want. Let me know.<br />
<br />
Regards,<br />
<br />
Lee<br />

</div>


Hi,

I do have some SQL that calculates the working hours between 2 dates but it doesn't cater for the lunch break, however this shouldn't be hard to add in. The stored procedure also relies on a SQL function that finds out if each day is a working day. This function further relies on a table containing non-working days, like Good Friday etc. I can post it if you want. Let me know.

Regards,

Lee


<div>
Hi<br />
<br />
That sounds good...yeah please post it I'd like to check out.<br />
<br />
Regards,<br />
Rui<br />

</div>


Hi

That sounds good...yeah please post it I'd like to check out.

Regards,
Rui


<div>
Excellent...Thanks. I have a public holiday table already setup for the sms program so it's all good.<br />
It did indeed help and saved me plenty time. Thanks. The points are yours.<br />
<br />
&nbsp;
</div>


Excellent...Thanks. I have a public holiday table already setup for the sms program so it's all good.
It did indeed help and saved me plenty time. Thanks. The points are yours.

 

<div>
<div class="content wysiwyg-content">
Hi<br />
<br />
I am trying to calculate working hours from a table using sql, I currently have a Startdate eg. &quot;29/06/2006 08:29:12&quot; and a EndDate eg. &quot;17/07/2006 08:32:28&quot;. <br />
The working hours are specified as 08:15 - 13:00 (Lunch) and 14:00-16:30, Monday to Friday.<br />
<br />
Can anyone show me a way to calculate working hours using Sql or would it be best to write a program to calculate this?<br />
<br />
<br />
Thanks<br />
Rui<br />
<br />
&nbsp;
</div>
</div>


Hi

I am trying to calculate working hours from a table using sql, I currently have a Startdate eg. "29/06/2006 08:29:12" and a EndDate eg. "17/07/2006 08:32:28". 
The working hours are specified as 08:15 - 13:00 (Lunch) and 14:00-16:30, Monday to Friday.

Can anyone show me a way to calculate working hours using Sql or would it be best to write a program to calculate this?


Thanks
Rui

 

calculate working hours in sql

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.