substrac datetime

Vahid Bakhtiary

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

8 Replies

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

Vulpes13y ago
Accepted 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 < dt1)
{
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 <= 7)
{
total19to07 = t2 - t1;
}
else if (t1 <= 7 && t2 <= 15)
{
total19to07 = 7 - t1;
total07to15 = t2 - 7;
}
else if (t2 <= 15)
{
total07to15 = t2 - t1;
}
else if(t1 <= 7 && t2 <= 19)
{
total19to07 = 7 - t1;
total07to15 = 8;
total15to19 = t2 - 15;
}
else if(t1 <= 15 && t2 <= 19)
{
total07to15 = 15 - t1;
total15to19 = t2 - 15;
}
else if(t2 <= 19)
{
total15to19 = t2 - t1;
}
else if(t1 <= 7)
{
total07to15 = 8;
total15to19 = 4;
total19to07 = t2 - t1 - 12;
}
else if(t1 <= 15)
{
total07to15 = 15 - t1;
total15to19 = 4;
total19to07 = t2 - 19;
}
else if(t1 <= 19)
{
total15to19 = 19 - t1;
total19to07 = t2 - 19;
}
else
{
total19to07 = t2 - t1;
}
}
else
{
if (t1 <= 7)
{
total07to15 += 8;
total15to19 += 4;
total19to07 += 12 - t1;
}
else if (t1 <= 15)
{
total07to15 += 15 - t1;
total15to19 += 4;
total19to07 += 5;
}
else if (t1 <= 19)
{
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 <= 7)
{
total19to07 += t2;
}
else if (t2 <= 15)
{
total19to07 += 7;
total07to15 += t2 - 7;
}
else if (t2 <= 19)
{
total19to07 += 7;
total07to15 += 8;
total15to19 += t2 - 15;
}
else if (t2 < 24)
{
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("\n{0}\n{1}\n{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 Bakhtiary13y ago
thanks for your tracking

it's correct
thanks
Vulpes13y ago
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 < dt1)
{
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 <= 7)
{
total19to07 = t2 - t1;
}
else if (t1 <= 7 && t2 <= 15)
{
total19to07 = 7 - t1;
total07to15 = t2 - 7;
}
else if (t2 <= 15)
{
total07to15 = t2 - t1;
}
else if(t1 <= 7 && t2 <= 19)
{
total19to07 = 7 - t1;
total07to15 = 8;
total15to19 = t2 - 15;
}
else if(t1 <= 15 && t2 <= 19)
{
total07to15 = 15 - t1;
total15to19 = t2 - 15;
}
else if(t2 <= 19)
{
total15to19 = t2 - t1;
}
else if(t1 <= 7)
{
total07to15 = 8;
total15to19 = 4;
total19to07 = t2 - t1 - 12;
}
else if(t1 <= 15)
{
total07to15 = 15 - t1;
total15to19 = 4;
total19to07 = t2 - 19;
}
else if(t1 <= 19)
{
total15to19 = 19 - t1;
total19to07 = t2 - 19;
}
else
{
total19to07 = t2 - t1;
}
}
else if (d2 == d1 && IsHoliday(d1))
{
total19to07 = t2 - t1;
}
else
{
if (t1 <= 7 && !IsHoliday(d1))
{
total07to15 += 8;
total15to19 += 4;
total19to07 += 12 - t1;
}
else if (t1 <= 15 && !IsHoliday(d1))
{
total07to15 += 15 - t1;
total15to19 += 4;
total19to07 += 5;
}
else if (t1 <= 19 && !IsHoliday(d1))
{
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 < d2)
{
if(!IsHoliday(temp))
{
total07to15 += 8;
total15to19 += 4;
total19to07 += 12;
}
else
{
total19to07 += 24;
}
temp = temp.AddDays(1);
}
}

if (t2 <= 7)
{
total19to07 += t2;
}
else if (t2 <= 15 && !IsHoliday(d2))
{
total19to07 += 7;
total07to15 += t2 - 7;
}
else if (t2 <= 19 && !IsHoliday(d2))
{
total19to07 += 7;
total07to15 += 8;
total15to19 += t2 - 15;
}
else if (t2 < 24 && !IsHoliday(d2))
{
total07to15 += 8;
total15to19 += 4;
total19to07 += t2 - 12;
}
else if (t2 < 24 && IsHoliday(d2))
{
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("\n{0}\n{1}\n{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 Bakhtiary13y ago
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 Bakhtiary13y ago
thanks for your help
Vahid Bakhtiary13y ago
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
Vulpes13y ago
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 < 15)
return HoursDifference.From07To15;
else if (diff >= 15 && diff < 19)
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(8,2));
}

}
Matija Sovic13y ago
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!