substrac datetime

Question

hi
i need to calculate different between DateTime
i have 2 param for start date and end date
for example 2013/01/01 10:30 & 2013/01/03 17:00

and i need thet return count hourse between 07 util 15 and from 15 util 19 and from 19 util 07

please help me how to solve it
thanks

Vulpes · Answer

Sorry I misunderstood the question :( Try this instead: using System; class HoursDifference { public double From07To15 { get; set; } public double From15To19 { get; set; } public double From19To07 { get; set; } public HoursDifference(DateTime dt1 DateTime dt2) { if (dt2 { DateTime temp = dt1; dt1 = dt2; dt2 = temp; } double t1 = dt1.TimeOfDay.TotalHours; double t2 = dt2.TimeOfDay.TotalHours; if (t2 == 0) t2 = 24; DateTime d1 = dt1.Date; DateTime d2 = dt2.Date; double total07to15 = 0; double total15to19 = 0; double total19to07 = 0; if (d1 == d2) { if (t2 { total19to07 = t2 - t1; } else if (t1 { total19to07 = 7 - t1; total07to15 = t2 - 7; } else if (t2 { total07to15 = t2 - t1; } else if(t1 { total19to07 = 7 - t1; total07to15 = 8; total15to19 = t2 - 15; } else if(t1 { total07to15 = 15 - t1; total15to19 = t2 - 15; } else if(t2 { total15to19 = t2 - t1; } else if(t1 { total07to15 = 8; total15to19 = 4; total19to07 = t2 - t1 - 12; } else if(t1 { total07to15 = 15 - t1; total15to19 = 4; total19to07 = t2 - 19; } else if(t1 { total15to19 = 19 - t1; total19to07 = t2 - 19; } else { total19to07 = t2 - t1; } } else { if (t1 { total07to15 += 8; total15to19 += 4; total19to07 += 12 - t1; } else if (t1 { total07to15 += 15 - t1; total15to19 += 4; total19to07 += 5; } else if (t1 { total15to19 += 19 - t1; total19to07 += 5; } else { total19to07 += 24 - t1; } int middleDays = (d2 - d1).Days - 1; if (middleDays > 0) { total07to15 += 8 * middleDays; total15to19 += 4 * middleDays; total19to07 += 12 * middleDays; } if (t2 { total19to07 += t2; } else if (t2 { total19to07 += 7; total07to15 += t2 - 7; } else if (t2 { total19to07 += 7; total07to15 += 8; total15to19 += t2 - 15; } else if (t2 { total07to15 += 8; total15to19 += 4; total19to07 += t2 - 12; } } From07To15 = total07to15; From15To19 = total15to19; From19To07 = total19to07; } public override string ToString() { string message1 = Hours between 07 and 15 =  + From07To15; string message2 = Hours between 15 and 19 =  + From15To19; string message3 = Hours between 19 and 07 =  + From19To07; return String.Format(
{0}
{1}
{2} message1 message2 message3); } } class Program { static void Main() { Console.Write(Enter first date : ); DateTime dt1 = DateTime.Parse(Console.ReadLine()); Console.Write(Enter second date : ); DateTime dt2 = DateTime.Parse(Console.ReadLine()); HoursDifference hd = new HoursDifference(dt1 dt2); Console.WriteLine(hd); Console.ReadKey(); } }

Vahid Bakhtiary · Answer

thanks for your tracking it's correct thanks

Vulpes · Answer

If all hours worked on a holiday (Thursday or Friday) count as if they were from 19 to 07 then try this amended version: using System; class HoursDifference { public double From07To15 { get; set; } public double From15To19 { get; set; } public double From19To07 { get; set; } public HoursDifference(DateTime dt1 DateTime dt2) { if (dt2 { DateTime temp = dt1; dt1 = dt2; dt2 = temp; } double t1 = dt1.TimeOfDay.TotalHours; double t2 = dt2.TimeOfDay.TotalHours; if (t2 == 0) t2 = 24; DateTime d1 = dt1.Date; DateTime d2 = dt2.Date; double total07to15 = 0; double total15to19 = 0; double total19to07 = 0; if (d1 == d2 && !IsHoliday(d1)) { if (t2 { total19to07 = t2 - t1; } else if (t1 { total19to07 = 7 - t1; total07to15 = t2 - 7; } else if (t2 { total07to15 = t2 - t1; } else if(t1 { total19to07 = 7 - t1; total07to15 = 8; total15to19 = t2 - 15; } else if(t1 { total07to15 = 15 - t1; total15to19 = t2 - 15; } else if(t2 { total15to19 = t2 - t1; } else if(t1 { total07to15 = 8; total15to19 = 4; total19to07 = t2 - t1 - 12; } else if(t1 { total07to15 = 15 - t1; total15to19 = 4; total19to07 = t2 - 19; } else if(t1 { total15to19 = 19 - t1; total19to07 = t2 - 19; } else { total19to07 = t2 - t1; } } else if (d2 == d1 && IsHoliday(d1)) { total19to07 = t2 - t1; } else { if (t1 { total07to15 += 8; total15to19 += 4; total19to07 += 12 - t1; } else if (t1 { total07to15 += 15 - t1; total15to19 += 4; total19to07 += 5; } else if (t1 { total15to19 += 19 - t1; total19to07 += 5; } else { total19to07 += 24 - t1; } int middleDays = (d2 - d1).Days - 1; if (middleDays > 0) { DateTime temp = d1.AddDays(1); while(temp { if(!IsHoliday(temp)) { total07to15 += 8; total15to19 += 4; total19to07 += 12; } else { total19to07 += 24; } temp = temp.AddDays(1); } } if (t2 { total19to07 += t2; } else if (t2 { total19to07 += 7; total07to15 += t2 - 7; } else if (t2 { total19to07 += 7; total07to15 += 8; total15to19 += t2 - 15; } else if (t2 { total07to15 += 8; total15to19 += 4; total19to07 += t2 - 12; } else if (t2 { total19to07 += t2; } } From07To15 = total07to15; From15To19 = total15to19; From19To07 = total19to07; } public override string ToString() { string message1 = Hours between 07 and 15 =  + From07To15; string message2 = Hours between 15 and 19 =  + From15To19; string message3 = Hours between 19 and 07 =  + From19To07; return String.Format(
{0}
{1}
{2} message1 message2 message3); } private bool IsHoliday(DateTime dt) { if (dt.DayOfWeek == DayOfWeek.Thursday || dt.DayOfWeek == DayOfWeek.Friday) { return true; } return false; } } class Program { static void Main() { Console.Write(Enter first date : ); DateTime dt1 = DateTime.Parse(Console.ReadLine()); Console.Write(Enter second date : ); DateTime dt2 = DateTime.Parse(Console.ReadLine()); HoursDifference hd = new HoursDifference(dt1 dt2); Console.WriteLine(hd); Console.ReadKey(); } }

Vahid Bakhtiary · Answer

thanks for your help Vulpes i meet a problem calculate Holidays namely if between 2013/01/01 10:00 and 2013/01/10 was Thursday and Friday the hours calculate for From19To07 for example in a day is 24 hour if it was Thursday and Friday the hour don't add to From07To15 and From15To19 and add to From19To07 From19To07+=24 please help me for solve it thanks

Vahid Bakhtiary · Answer

thanks for your help

Vahid Bakhtiary · Answer

thanks for your answer but it isn't my means in a day time start from 07:00 util 07:00 next day and i get 2 paramaters date for example 2013/01/01 10:00 & 2013/01/02 10:00 now i want calculate it that many hour is between 07:00 util 15:00 and many hour is between 15:00 util 19:00 and many hour between 19:00 util 07:00 for example for up parameter 7-15 -> 8 15-19 -> 4 19-7 -> 12 if it isn't clear tell me

Vulpes · Answer

Try this: using System; enum HoursDifference { From07To15 From15To19 From19To07 } class Program { static void Main() { Console.Write(Enter first date : ); DateTime dt1 = DateTime.Parse(Console.ReadLine()); Console.Write(Enter second date : ); DateTime dt2 = DateTime.Parse(Console.ReadLine()); HoursDifference hd = GetHoursDifference(dt1 dt2); PrintHoursDifference(hd); Console.ReadKey(); } static HoursDifference GetHoursDifference(DateTime dt1 DateTime dt2) { int diff = (int)(dt2 - dt1).TotalHours; diff = diff % 24; if (diff >= 7 && diff return HoursDifference.From07To15; else if (diff >= 15 && diff return HoursDifference.From15To19; else return HoursDifference.From19To07; } static void PrintHoursDifference(HoursDifference hd) { string hds = hd.ToString(); Console.WriteLine(From {0} to {1} hds.Substring(4 2) hds.Substring(82)); } }

Matija Sovic · Answer

Here is a article that can help you! http://www.c-sharpcorner.com/UploadFile/mahesh/working-with-datetime-using-C-Sharp/ You need to use TimeSpan!