C# Time Calculation Logic Required :(

narasimman g

Hi All,

Always i feel Time calculation bit hectic than anything..

Please consider the following Rules for Time Calculation:

1.
Working hours is only considered 11.30 hours (One full day is 11.30 not 24 hours)...

if date A = 24/05/2011 05:08:56
if date B = 26/05/2011 07:08:58

2.
only fully day is 11.30( 10.30 - 22.00) ...So for first and last day we have to subract and add the time (we can not take it as 11.30 hours).

Output

I want to subract Two dates and Produce Output as Hours:Minutes:Seconds

Advanced Thanks

3 Replies

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

Sam Hobbs15y ago
I am not sure I understand the requirements but to the extent that I do, I think it would work to convert all time values to minutes and then do the calculations then convert back. So in other words there are 690 minutes in 11 hours and 30 minutes, correct? Next you need to specify what time is to be considered zero minutes and all other times will be relative to that time. In the case of the DateTime structure, it "represents dates and times with values ranging from 12:00:00 midnight, January 1, 0001" but it measures time in "100-nanosecond units called ticks" and that could be used but I think it would be equally convenient to use data that is measured in minutes relative to a more recent start time. You might want to create a class to help isolate the logic and make it easier to re-use.
0
Vulpes15y ago
This is more complicated than it looks but try the following:

using System;

class Test
{
static void Main()
{
DateTime A = DateTime.Parse("24/05/2011 05:08:56");
DateTime B = DateTime.Parse("26/05/2011 07:08:58");

DateTime tempA = A.AddHours(24).Date;
DateTime tempB = B.Date;
double hours = (tempB - tempA).Days * 11.5;
double hoursA;
DateTime temp2A = A.Date.AddHours(10.5);
DateTime temp3A = A.Date.AddHours(22);
if (A >= temp3A)
{
hoursA = 0;
}
else if (A <= temp2A)
{
hoursA = 11.5;
}
else
{
hoursA = (A - temp2A).TotalHours;
}

double hoursB;
DateTime temp2B = tempB.AddHours(10.5);
DateTime temp3B = tempB.AddHours(22);
if (B <= temp2B)
{
hoursB = 0;
}
else if (B >= temp3B)
{
hoursB = 11.5;
}
else
{
hoursB = (B - temp2B).TotalHours;
}

if (hours == 0)
{
hoursA = hoursB - hoursA;
hoursB = 0;
}

TimeSpan ts = TimeSpan.FromHours(hours) + TimeSpan.FromHours(hoursA) + TimeSpan.FromHours(hoursB);
Console.WriteLine("{0}:{1:D2}:{2:D2}", ts.Days * 24 + ts.Hours, ts.Minutes, ts.Seconds);
Console.ReadKey();
}
}

This should give an answer of 23:00:00 because there's a full day on 24 May (from 10.30 to 22.00), a full day on 25 May but no hours are worked on 26 May because the finishing time is before 10.30.
0
Jiteendra Sampathirao15y ago
Hi,
Try this:

    DateTime strdt= Convert.ToDateTime("04/14/2011");
    DateTime enddt= Convert.ToDateTime("04/07/2010");
    TimeSpan ts = strdt.Subtract(enddt);
    int day = ts.Days;
0