work-hours

What is the best way to wrap time around the work day?

I have a situation where I want to add hours to a date and have the new date wrap around the work-day. I cobbled up a function to determine this new date, but want to make sure that I'm not forgetting anything. The hours to be added is called "delay". It could easily be a parameter to the function instead. Please post any suggestions. ...

How many concurrent projects can a senior developer handle at one time?

I am trying to find sensible resource-allocation models for developers. The department will have many different projects for different external customers, so I need to make some guidelines in order to avoid people getting angry due to lack of focus, not working on things they want to, etc. Currently I have suggestion for a model: Ju...

Calculating a date around working days/hours?

I am currently working on a website to track projects. In it, it is possible to create Service Level Agreements (SLAs). These are configurable with days of the week that a project can be worked on and also the timespan on each of those days. Eg. on Monday it might be between 08:00 and 16:00 and then on friday from 10:00 to 14:00. They ar...

What is a fair hourly charge for routine site updates?

What do you consider a fair, yet profitable hourly wage for routine updates/management (ie - information, maintenance, database management) for your average site? What factors do you use to set that rate? As a reference...I usually quote around $25/hour...am I getting ripped? EDIT: Initially I was hoping for this to be a good referenc...

T-Sql 2005 Adding hours to a datetime field with the result within working hours

I have two Datetime fields that I wish to add together. They are in the following format: '01/01/1900 00:00:00'. The main issue with this is that I want the calculation to only include working hours. The working day is between 08:30 and 17:30 and does not include weekends: Also if the first field starts out of the working day or is on ...

When programming for an hourly rate, should you keep the timer running while processing code automatically in the background?

This is probably subjective as it is a dilemma between what is good for you and what is good for your customer, but I as a programmer, would really like to know what is the commonly accepted way of doing this. I will keep these answers to my question in mind for future projects. I've personally never sold any of my work using a set rate...

Excel Overtime Calculation

I need to calculate the number of hours and mins I have gone over 1 hour/60 mins. So if I did 1 hour and 6 mins of something and i write that in one cell (E9) I want the other cell (G9) to show 6 mins. So it shows I did 6 mins over the required 1 hour. If I did 2 hours and 40 mins (E9) I want the cell (G9) to show 1 hour and 40 mins. ...

Factoring in night shifts to a working hours calculator.

OK, Thanks to all of you that have helped with my quandry. However, there is one stumbling block - I need to factor in night shifts. For example, if the start time is 13h and the finish time is 2h - I want it to come up as 15h, not 11h. This is the code: -(IBAction)done:(id)sender { int result = (([startHours.text intValue] * 60) ...

Convert Office Hours to local time using JavaScript

How can I use JavaScript to add a message like this to a web page: Our office hours are 9am - 5pm (09:00 - 17:00) PST. In your timezone, that's WWxx - YYzz (AA:00 - BB:00). Where: "WW" and "YY" are converted to the proper values for "hour" (on the 12 hour clock). "xx" and "zz" are converted to either "am" or "pm". "AA" and "...