Add Date time as per woking Hours

mithun kumar

14y3.6k.NET

Hello Friends,

Assume now the current Date Time is 27-05-12 15:00

I want to add:-1 days 5 hours 00 min

Suppose your working Hour is 9:00 to 17:00(5'o clock)

1-You got one task at 27-05-12 15:00 (Date time)
2-And you said I will take 13 hours to complete this task.
3-That's mean today you have 2 Hours(15:00 to 17:00) work and tomorrow 8(9:00 to 17:00) Hours works and day after tomorrow 3(9:00 to 12:00) hours works to finish 13 hours. So the Output date time to finish this task will be will be as follows

Output should be:
29-05-12 12:00

Note: conclusion is that when you will say I will take 780 min or 13 Hours system automatically calculate the finish Date time

Thanks & Regards,

Mithun.

8 Replies

Know the answer? Post it — somebody with the same question will find it here.

Vulpes14y ago
Accepted answer
Try:

using System;

class Program
{
static void Main()
{
DateTime start = DateTime.Parse("27-05-12 15:00");
DateTime end = AddTimeSpan(start, 1, 5, 0);
Console.WriteLine(end.ToString("dd-MM-yy HH:mm"));
Console.ReadKey();
}

static DateTime AddTimeSpan(DateTime start, int days, int hours, int mins)
{
if (start.Hour < 9)
{
start = start.Date.AddHours(9);
}
else if (start.Hour >= 17)
{
start = start.Date.AddDays(1).AddHours(9);
}

double totalHours = days * 8 + hours + (mins/60.0);
if (totalHours < 0) throw new ArgumentException("Timespan must be non-negative");
double currentHour = start.Hour + (start.Minute/60.0);

while(totalHours > 0)
{
double maxHours = 17 - currentHour;
if (totalHours <= maxHours) break;
totalHours -= maxHours;
start = start.Date.AddDays(1).AddHours(9);
currentHour = 9;
}

return start.AddHours(totalHours);
}
}
mithun kumar14y ago
Dear Vulpes ,

Excellent Work,thanks a lot.

Thanks & Regards,
Mithun.
mithun kumar14y ago
Dear kingskunal,

Excellent Work,thanks a lot.

Thanks & Regards,
Mithun.
mithun kumar14y ago
Dear,

no matter for saturday and sunday...it will be same.

Thanks & Regards,
Mithun.
Kunal Vaishya14y ago
Dear

working Hrs is Same for all day and what about Saturday and Sunday ?
mithun kumar14y ago
Dear Friends,

Thanks for your reply.it is adding the Date time.but As i told in my post...i want to add this as per my working hours.i,e the day will finish after 1700 Hrs and next day will start after 9'o clock morning.
Suppose...
1-I got one task at 28-05-12 15:00 (Date time)
2-And I said I will take 13 hours to complete this task.
3-That's mean today I have 2 Hours(15:00 to 17:00) work and tomorrow 8(9:00 to 17:00) Hours works and day after tomorrow 3(9:00 to 12:00) hours works to finish 13 hours. So the Output date time to finish this task will be will be as follows

Output should be:
30-05-12 12:00

Thanks & Regards,
Mithun.
Ehtesham14y ago
DateTime dt = DateTime.Now;
dt = dt + new TimeSpan(1, 5, 0, 0);
Kunal Vaishya14y ago
Dear

try this code it will help you

        private void dateAddFucntion()
        {
            DateTime dt = DateTime.Now;
            dt = dt.AddDays(1);
            dt = dt.AddHours(5);
            dt = dt.AddMinutes (0);
            //MessageBox.Show(dt.ToString());
        }