Calculating total time for a week

[NareshN]

Hi All,

I am calculating totaltime of the employee for each day.I want weekly totaltime working hours.I am using for loop to calculate totaltime for 1 week.But i am storing Total time in String.How to add totaltime for week.
If i use DateTime i am getting date also but i want only time.

TotalTime - 9:00 for 1 day.

I should use Static variable to keep the Previous TotalTime in varible so that i can add previous and current day totaltime.

This is my code

 for (int i = 3; i < count; i++)
                {
 string[] TimeSplit = SpliData(strData);
                        //TimeIn.Add(Convert.ToDateTime(TimeSplit[0]));
                        //TimeOut.Add(Convert.ToDateTime(TimeSplit[1]))
                        string TimeValue = TimeSplit.ToString();
                        string frmtimestring = TimeSplit[0];
                        string toTimeString = TimeSplit[1];
                        int frmTime = Convert.ToInt32(frmtimestring.Replace(":", ""));
                        int totime = Convert.ToInt32(toTimeString.Replace(":", ""));
                        if (frmTime > totime)
                        {
                            totime = totime + 2400;
                        }
                        string TotalTime = Convert.ToString(frmTime - totime).Replace("-", "");
                        TotalTime = TotalTime.Substring(0, TotalTime.Length - 2) + ":" +TotalTime.Substring(TotalTime.Length - 2);
}

[Frinavale]

When you have to do calculations that involve time you should stick with using DateTime structures and TimeSpan structures.

Store the start time in a DateTime structure variable (called something like startTime) and store the end time in a DateTime structure (called something like endTime).

You can subtract DateTime structures...but when you do this you get a TimeSpan as a result. The TimeSpan will include details on how many days, minutes, hours, seconds, milliseconds difference there was between the two DateTime objects.

For Example:
(VB.NET)

Dim startTime As DateTime
DateTime.TryParse("9:00", startTime)
'you could also use: DateTime.TryParse("9:00 AM", startTime)
 
Dim endTime As DateTime
DateTime.TryParse("17:00", endTime)
'you could also use: DateTime.TryParse("5:00 PM", endTime)
 
Dim workInterval As TimeSpan = endTime - startTime
 
Dim numHoursWorked As Integer = workInterval.Hours
 

(C#)

DateTime startTime;
DateTime.TryParse("9:00", startTime);
//you could also use: DateTime.TryParse("9:00 AM", startTime);
 
DateTime endTime;
DateTime.TryParse("17:00", endTime);
//you could also use: DateTime.TryParse("5:00 PM", endTime);
 
TimeSpan workInterval = endTime - startTime;
 
Integer numHoursWorked = workInterval.Hours;
 

-Frinny

[nathaliecruz]

Hi,

We have been using employee time card software from Replicon to calculate log-in and log-out time of our employees.

There are great benefits a business can get from this great software. You can use it to make instant payments and track your employees time spent on different tasks more accurately.