By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,594 Members | 2,062 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,594 IT Pros & Developers. It's quick & easy.

How to Calculate the Employee TimeSheet

P: 30
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.... :)
Dec 18 '07 #1
Share this Question
Share on Google+
8 Replies


debasisdas
Expert 5K+
P: 8,127
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?
Dec 18 '07 #2

Expert 5K+
P: 8,434
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.
Dec 18 '07 #3

P: 30
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.
Dec 19 '07 #4

lotus18
100+
P: 866
Hi

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

e.g.

Expand|Select|Wrap|Line Numbers
  1. Dim total As String
  2. Dim timein As Date, timeout As Date
  3. timein = #8:00:00 AM#
  4. timeout = #5:00:00 PM#
  5.  
  6. total = DateDiff("n", timein, timeout)
Rey Sean
Dec 19 '07 #5

P: 30
Hi

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

e.g.

Expand|Select|Wrap|Line Numbers
  1. Dim total As String
  2. Dim timein As Date, timeout As Date
  3. timein = #8:00:00 AM#
  4. timeout = #5:00:00 PM#
  5.  
  6. total = DateDiff("n", timein, timeout)
Rey Sean
thanks for your help....
one more question, in time we use military time, is it the same??? or not???


tnx...
Dec 19 '07 #6

Expert 5K+
P: 8,434
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.
Dec 19 '07 #7

lotus18
100+
P: 866
Hi Serenityquinn15

You're welcome

Rey Sean
Dec 20 '07 #8

P: 30
Hi Serenityquinn15

You're welcome

Rey Sean
Thanks. It works fine... hehehe....
Dec 20 '07 #9

Post your reply

Sign in to post your reply or Sign up for a free account.