Tips in making TIME KEEPING System

[bizzy_e23]

Good day.

Im a new user of VB.net, i just want to get the total hours an employee attended. For example, an employee checks In at 11:30 PM in the evening and Checks Out the next day at 8:30 AM in the morning.


I just need the total hours and minutes... THANKS!!!

[Zeljko]

See help for TimeSpan.

Use DateTime var for both times/dates and substract them.

EDIT:
Here is a sample:

Dim oDt1 As DateTime = first.Value 'datetime picker 1
Dim oDt2 As DateTime = second.Value 'datetime picker 2
Dim oDtDiff As TimeSpan = oDt2.Subtract(oDt1)
Dim hours As Integer
Dim minutes As Integer
        hours = DateDiff(DateInterval.Hour, first.Value, second.Value)
        minutes = DateDiff(DateInterval.Minute, first.Value, second.Value)
        
Me.txtDiffSec.Text = oDtDiff.ToString 'textbox where result with seconds goes  (05:45.23.295468)
Me.txtDiff.Text = hours & ":" & Math.Round(((minutes / 60) - hours) * 60, 0) 'text box for mins:sec (05:45)

[bizzy_e23]

Im using MS Access 2007 as my database, will it work there?

[Zeljko]

I dont see a problem

[bizzy_e23]

Thank you very much, i'll try it, i'll just have to finish the sample data inputs.

[Zeljko]

If everything is resolved mark thread resolved (thread tools - Mark thread resolved)

[bizzy_e23]

How about using the Datagrid view object, how can i create a simple connection to the database? Im sorry, it's my first time to use VB.net I'm much famillar in VB 6.0 but i need to learn this .net also.. Thanks

[Zeljko]

Sorry, dont know how to help you with that. I'm also at beginning with VB.net. Maybe will someone else answer to this question, but I sugest that you make a search first in this forum, than in MSDN, then Google