Calculating total numbersof hours for attendance

Question

Am Working on Attendance system in asp.net, I have two labels and Textboxes:

Textbox1 for Time entry.
Textbox2 for leave entry.

Both are inputted by user in terms for example: Entry time is: (7:50 AM) and the Leave time is: (6:15 PM). Now I want to calculate the total numbers of hours for the inputted entries. keeping in mind in the day he/she has 30 minutes break. So how to do that?

It would depend on the database engine you are using. – Dan Bracuk Sep 15 '13 at 12:00 — Dan Bracuk, Sep 15 '13 at 12:00

score 2 · Accepted Answer · edited May 23 '17 at 12:14

2

Convert TextBox1.Text to System.DateTime entry
Convert TextBox2.Text to System.DateTime leave
Calculate Timespan t = leave - entry - Timespan.FromMinutes(30)
Get t.TotalHours()

For converting time string into DateTime use DateTime.ParseExact ( Why can’t DateTime.ParseExact() parse the AM/PM in “4/4/2010 4:20:00 PM” using “M'/'d'/'yyyy H':'mm':'ss' 'tt” )

    var ci = new CultureInfo("en-US");

    DateTime entry = DateTime.ParseExact("7:50 AM", "h:mm tt", ci);
    DateTime leave = DateTime.ParseExact("6:15 PM", "h:mm tt", ci);

    TimeSpan t = leave - entry - TimeSpan.FromMinutes(30);

    var totalTime = string.Format("{0:D2}h:{1:D2}m", t.Hours, t.Minutes);

edited May 23 '17 at 12:14

Community

1
1

answered Sep 15 '13 at 12:00

Nemanja Boric

21,627
6
67
91

The question says total hours. – Dan Bracuk Sep 15 '13 at 12:01
@DanBracuk I don't understand, are you proposing that I should use `t.Hours()` instead? – Nemanja Boric Sep 15 '13 at 12:02
Just to add some formatting, you could use `var totalTime = string.Format("{0:D2}h:{1:D2}m", t.Hours, t.Minutes);` to get hours and mins. – Christian Phillips Sep 15 '13 at 12:22
@NemanjaBoric, I think "total hours for the inputted entries" means a database query to get previously entered values as well. Of course, the question does not explicitly state that. – Dan Bracuk Sep 15 '13 at 12:44

Calculating total numbersof hours for attendance

1 Answers1