Printable View
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!!!
See help for TimeSpan.
Use DateTime var for both times/dates and substract them.
EDIT:
Here is a sample:
Code: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)
Im using MS Access 2007 as my database, will it work there?
I dont see a problem
Thank you very much, i'll try it, i'll just have to finish the sample data inputs.
If everything is resolved mark thread resolved (thread tools - Mark thread resolved)
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
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 :D