TimeSpan between Business Days

[pkj7461]

Hi,
I was looking for the code to return Timespan between any two days. The days should exclude weekends, saturday and sunday.
Like, for example,
startdate = "10/5/2007 10:00:00 AM"
enddate = "10/9/2007 11:30:00 AM"

The function should return the Timespan between these two days excluding Saturday and Sunday...
Timespan ts = 1:12:30:00

Thanks in Advance,
PKJ

[Shashi Sadasivan]

Hi,
I was looking for the code to return Timespan between any two days. The days should exclude weekends, saturday and sunday.
Like, for example,
startdate = "10/5/2007 10:00:00 AM"
enddate = "10/9/2007 11:30:00 AM"

The function should return the Timespan between these two days excluding Saturday and Sunday...
Timespan ts = 1:12:30:00

Thanks in Advance,
PKJ

DateTime startDate = DateTime.Now;
            DateTime endDate = DateTime.Now.AddDays(20);
            TimeSpan ts = endDate.Subtract(startDate);
            Console.WriteLine(ts.ToString());
            int weekends = 0;
            for (DateTime tempDt = startDate; tempDt < endDate; tempDt = tempDt.AddDays(1))
            {
                if (tempDt.DayOfWeek == DayOfWeek.Saturday || tempDt.DayOfWeek == DayOfWeek.Sunday)
                    weekends++;
            }
            ts = ts.Subtract(new TimeSpan(weekends, 0, 0, 0));
            Console.WriteLine(ts.ToString());

does this help you?

cheers

[pkj7461]

Hi,
Sorry for delay in replying.
This seems to be not working. It gives the timespan including weekends.
Thanks,
Prasanna

DateTime startDate = DateTime.Now;
            DateTime endDate = DateTime.Now.AddDays(20);
            TimeSpan ts = endDate.Subtract(startDate);
            Console.WriteLine(ts.ToString());
            int weekends = 0;
            for (DateTime tempDt = startDate; tempDt < endDate; tempDt = tempDt.AddDays(1))
            {
                if (tempDt.DayOfWeek == DayOfWeek.Saturday || tempDt.DayOfWeek == DayOfWeek.Sunday)
                    weekends++;
            }
            ts = ts.Subtract(new TimeSpan(weekends, 0, 0, 0));
            Console.WriteLine(ts.ToString());

does this help you?

cheers

[Shashi Sadasivan]

Could you please give some input dates (start and end).

I tested it, and it was working allright.
Once you send some test data.....I can check it again.

Have you in anyways modified the code anywhere?

cheers

[pkj7461]

Hi Shashi,
I was working on weekend with the code. I changed the input to
Start Date = "10/4/2007 3:26:00 PM"
endDate = " 10/7/2007 9:24:00 PM"

I ran the code and changed the format of output to "hh:mm"
My output was 29:58
and the actual output should be 32:33.
I noticed one more thing. The output seems to be changing every minute even during weekend.
Thank you very much for your time and efforts.
Prasanna.

Could you please give some input dates (start and end).

I tested it, and it was working allright.
Once you send some test data.....I can check it again.

Have you in anyways modified the code anywhere?

cheers

[Shashi Sadasivan]

Checking your specifications :
you wanted the timespan between business days :)
But in your first post you wanted between any 2 days.

I went along with the title "between 2 business days"
(why do you want staff to work on weekends :P)
7th of 10 is not a business day.

so now you know where to modify the code.

cheers

[Plater]

Well DateTime objects have that "Day of the week" property.
You can create DateTime objects for each whole "day" inbetween your two dates. If the dayoftheweek is not a weekend day, add 24?
That's a really simplified reasoning on it, but then you just have to find the "used" time on the start/end day, assuming they are "week days"