Calculate the number of business hours between two dates.

  • Thread starter Thread starter Mufasa
  • Start date Start date
M

Mufasa

Anybody have a function that will calculate the number of business hours
between two dates? I will assume eight hours a day and don't want to count
weekends.

TIA - Jeff.
 
Anybody have a function that will calculate the number of business hours
between two dates? I will assume eight hours a day and don't want to count
weekends.

TIA - Jeff.
Click to expand...

Hi,

Not that I know of, but it wound be rocket science to build one.

If you add holidays it gets more difficult htough :)
 
Mufasa said:
Anybody have a function that will calculate the number of business hours
between two dates? I will assume eight hours a day and don't want to count
weekends.
Click to expand...
Well, then, here's close to half the solution:

int countBusinessHours(int days) {
return days * 8;
}

The other function is left as an exercise to the reader. The DateTime class
has everything you need.
 
Well, then, here's close to half the solution:

int countBusinessHours(int days) {
return days * 8;
}

The other function is left as an exercise to the reader. The DateTime class
has everything you need.
Click to expand...

Heres the rest. .i think..


DateTime d1 = DateTime.Now;
DateTime d2 = DateTime.Now;
TimeSpan s = d2.Subtract(d1);

DateTime nd;

int businessdayCounter = 0;
for (int i = 0; i < s.Days; i++)
{
nd = d1.AddDays(i);

if (nd.DayOfWeek == DayOfWeek.Saturday || nd.DayOfWeek
== DayOfWeek.Sunday)
{
// ignore
}
else
{
businessdayCounter++;
}
}
 
Hi Jeff,

I need to program a function to determine an expiration datetime from a specific datetime, for instance NOW.

The problem that I have using Datetime class is that I cannot find the way to set the workday in 8 hours. The rest of the function works very well, but the expiration datetime is calculated using 24-hours day.

I would like your advice on how can I solve this problem.

Thanks, Guillermo from Costa Rica
 
Back
Top