469,964 Members | 1,492 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,964 developers. It's quick & easy.

How to Calculate the Employee TimeSheet

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
8 6087
debasisdas
8,127 Expert 4TB
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
Killer42
8,435 Expert 8TB
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
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
866 512MB
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
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
Killer42
8,435 Expert 8TB
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
866 512MB
Hi Serenityquinn15

You're welcome

Rey Sean
Dec 20 '07 #8
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.

Similar topics

1 post views Thread by harsha mogaligundla | last post: by
reply views Thread by Redz | last post: by
1 post views Thread by rainxy | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.