Calculating Working Hours

Question

Post reply

Calculating Working Hours

Luis Cazares

SSC Guru

Points: 183706
More actions
July 8, 2014 at 8:39 pm

#290701

Comments posted to this topic are about the item Calculating Working Hours
Luis C.
General Disclaimer:
Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?
How to post data/code on a forum to get the best help: Option 1 / Option 2

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Vimal Lohani SSCommitted Points: 1650 More actions · Answer 1

Interesting Script. 🙂

But it is not a good practice,

Although you have described every thing about the script, You should create script dynamically because all organizations have different timings,

Scholars have to make changes in whole script according to their need and time gaps.

Vimal LohaniSQL DBA | MCP (70-461,70-462)==============================The greatest barrier to success is the fear of failure ** Success is a journey not a destination**Think before you print, SAVE TREES, Protect Mother Nature

Luis Cazares SSC Guru Points: 183706 More actions · Answer 2

That's true, but this could work as a guide. This script was originated from a forum post and I thought of sharing it even if it can't be used as it is for most people, it can help for examples.

Thank you for the comment.

Luis C.
General Disclaimer:
Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

How to post data/code on a forum to get the best help: Option 1 / Option 2

Vimal Lohani SSCommitted Points: 1650 More actions · Answer 3

Your welcome dear!

Still it is difficult to understand and change the script.

Vimal LohaniSQL DBA | MCP (70-461,70-462)==============================The greatest barrier to success is the fear of failure ** Success is a journey not a destination**Think before you print, SAVE TREES, Protect Mother Nature

Pyman SSChampion Points: 13830 More actions · Answer 4

Where shd i make changes to the script if work hours are 9:00AM to 6:00PM and Lunch hours are 12:00PM to 1:00PM?

Thanks

“If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams

akljfhnlaflkj SSC Guru Points: 76202 More actions · Answer 5

Luis Cazares (8/5/2014)
That's true, but this could work as a guide. This script was originated from a forum post and I thought of sharing it even if it can't be used as it is for most people, it can help for examples.

Thanks for the model.