How to Calculate the Employee TimeSheet

[Serenityquinn15]

Hi!

I just want to know, how to calculate the employee timesheet it's a part of payroll system. and it is my first time to create a system like this. I need to determine the Overtime, Late and undertime of each employee, Please Help me...


Thanks.... :)

[debasisdas]

What exactly are you developing?
Does it involve any database, if so what is the database?
Kindly pass a few more details.

How do you expect us to suggest anything without having any knowledge of what is happening on your side?

[Killer42]

TheScripts may not be the best site for this sort of question. We're geared more toward helping with programming problems while building software, not designing the software in the first place.

On the other hand, of course, you might get lucky.

[Serenityquinn15]

What exactly are you developing?
Does it involve any database, if so what is the database?
Kindly pass a few more details.

How do you expect us to suggest anything without having any knowledge of what is happening on your side?

Yes, it is involve in my database, I'm using MS Access database.
The interface that I'm using is Visual Basic 6.0, can you please give me some sample of code to compute the total of minutes?
Here is the example:

TimeIN : 8:00 am
TimeOut: 17:00 pm

What I really need is the code to compute the total of minutes per day.

I know how to compute it in Excel, but not in VB code. I'm a new beginner, and I'm very interested in Visual Basic.

Thanks.

[lotus18]

Hi

If you want to get the total no. of minutes of the two, you can use the DateDiff function.

e.g.

[CODE=vb]
Dim total As String
Dim timein As Date, timeout As Date
timein = #8:00:00 AM#
timeout = #5:00:00 PM#

total = DateDiff("n", timein, timeout)[/CODE]

Rey Sean

[Serenityquinn15]

Hi

If you want to get the total no. of minutes of the two, you can use the DateDiff function.

e.g.

[CODE=vb]
Dim total As String
Dim timein As Date, timeout As Date
timein = #8:00:00 AM#
timeout = #5:00:00 PM#

total = DateDiff("n", timein, timeout)[/CODE]

Rey Sean

thanks for your help....
one more question, in time we use military time, is it the same??? or not???


tnx...

[Killer42]

one more question, in time we use military time, is it the same??? or not???

Yes, VB can handle 12- or 24-hour time formats.

[lotus18]

Hi Serenityquinn15

You're welcome

Rey Sean

[Serenityquinn15]

Hi Serenityquinn15

You're welcome

Rey Sean

Thanks. It works fine... hehehe....