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.... :)
8 6368
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?
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.
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.
Hi
If you want to get the total no. of minutes of the two, you can use the DateDiff function.
e.g. -
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)
Rey Sean
Hi
If you want to get the total no. of minutes of the two, you can use the DateDiff function.
e.g. -
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)
Rey Sean
thanks for your help....
one more question, in time we use military time, is it the same??? or not???
tnx...
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.
Hi Serenityquinn15
You're welcome
Rey Sean
Hi Serenityquinn15
You're welcome
Rey Sean
Thanks. It works fine... hehehe....
Sign in to post your reply or Sign up for a free account.
Similar topics
by: harsha mogaligundla |
last post by:
Dear All ,
I am trying to develop a web based electronic
Timesheet system for the payroll department using ASP and
SQL server, the front end has fields like ssn,time -in ,
tim-out,regular...
|
by: Redz |
last post by:
About SocketTimesheet™
SocketTimeSheet is one of the most practical, affordable and user
friendly web-based time tracking software and expenses management
system in the market today - it's cheap,...
|
by: Chad Richardson |
last post by:
I would like a single SQL to return all employee's total billable
compensation for a year. Their billable rates change throughout the year so
under the employee table (one), there is a compensation...
|
by: SpyderSL |
last post by:
Hey,
I have created an access form, in which I have a drop down with employee names.
These are the steps I would like to happen:
1. A user will enter a number in FIELD A
2. The user will...
|
by: deena22 |
last post by:
hello,
i'm using 'Access database' and VB 6.0. My database is named ' timesheet' and it contains a table named 'tabletimesheet'. The table contain the following fields: 'staffname, stafftype,...
|
by: Sector 7G |
last post by:
I'm working with a SQL query for a Human Resources database. Its intended purpose is to find all the paycheck records with a check date (prckhist.chkdate ) more recent than eleven days past the...
|
by: MCLR |
last post by:
Good day to all: I found your website a couple of days ago as I was searching for resources that can help within my particular problem in writing a script for an Access Query. The issue is to...
|
by: alem |
last post by:
Hi Alem:
To calculate Employee work expereance in Ms-Access what shall I do b/c
I tried by the following formulas bu I got three or four month different I can't get exact service year and I...
|
by: lizBeth |
last post by:
Hi all,
i seem to have gotten stuck on this coursework, i am unsure as to how to implement a method in the main class to calculate the sum of all employees monthly salaries.
Everything...
|
by: CloudSolutions |
last post by:
Introduction:
For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
|
by: ryjfgjl |
last post by:
In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...
|
by: taylorcarr |
last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
|
by: aa123db |
last post by:
Variable and constants
Use var or let for variables and const fror constants.
Var foo ='bar';
Let foo ='bar';const baz ='bar';
Functions
function $name$ ($parameters$) {
}
...
|
by: ryjfgjl |
last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
| |