Calculating the Number of Business Hours Passed Since a Point of Tme

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Mazharuddin Ehsan » Calculating the Number of Business Hours...

44 posts, Page 5 of 5

«««1 2 3 4 5

Calculating the Number of Business Hours Passed Since a Point of Tme

Rate Topic

Display Mode

Topic Options

Author

Message

c1680222

Posted Monday, January 03, 2011 12:32 PM

Forum Newbie

Group: General Forum Members
Last Login: Thursday, January 06, 2011 4:55 AM
Points: 1, Visits: 12

Hello, it's a great tool for calculate SLA's

but I'm trying to use this for calculate saturday morning include (here (Brazil) we work in saturdays too)

can you help me to do this modification?

thank you

Post #1042025

sunnyplace

Posted Friday, March 18, 2011 12:29 PM

Forum Newbie

Group: General Forum Members
Last Login: Monday, April 04, 2011 12:21 PM
Points: 2, Visits: 16

Very nice job with the function that calculates time between two dates, I am working in a report that I need to calculate the number of working days less holidays and I was wondering if those functions can be modified to be used to calculate working days excluding holidays, I do not need to remove lunch hour. I am new in this, so I will appreciate a little guidance.

Post #1080628

Learning user

Posted Tuesday, March 27, 2012 1:24 AM

Forum Newbie

Group: General Forum Members
Last Login: Friday, June 15, 2012 4:51 AM
Points: 3, Visits: 12

hi

i am new to this forum

my problem is i have table to define the working hours of the employees based on that i need to calculate the hours

there is no such rule of common shift timeing

>>Problem statements

Have Creation date of ticket

Employee work in diffrent shift based on the World country they support

so weekoff and shift time are in one table

and list of holidays in another table

so now i need to calculate the time spent as of now... received time and current time - i should get the business hours

Table 1 : Shift start Time | Shift End time | Weekoff1 | weekoff2 |

Table 2 : Holidays

Result should be business hours

Post #1273239

Ian.Donaldson

Posted Tuesday, May 14, 2013 5:29 AM

Forum Newbie

Group: General Forum Members
Last Login: Thursday, May 16, 2013 7:41 AM
Points: 2, Visits: 8

I am confused I am just getting

I just keep getting error messages because of the dbo.DateAt...... I have checked through it and understand that this is saying the start and end times but confused on how this needs to be written so the function will work. HELP :)

Post #1452513

« Prev Topic | Next Topic »

44 posts, Page 5 of 5

«««1 2 3 4 5

Permissions