C# Time Calculation Logic Required :(

Question

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

Sam Hobbs · Answer

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.

Vulpes · Answer

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 { hoursA = 11.5; } else { hoursA = (A - temp2A).TotalHours; } double hoursB; DateTime temp2B = tempB.AddHours(10.5); DateTime temp3B = tempB.AddHours(22); if (B { 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.

Jiteendra Sampathirao · Answer

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;