473,386 Members | 1,819 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,386 software developers and data experts.

How to determine # of employees who worked during a time interval

1
Hi. My goal is to create a database where I can extract the number of employees who have worked during each one hour interval in a 24 hr day (00:00 - 1:00, 1:00 - 2:00,...11:00 - 11:59).

tEmployees contains the employees Punch in & outs for a given month. My problem is tracking the overnight employees working PM > AM. My whole design might be wrong, I'll take any feedback/design tips. Thanks
Jul 5 '12 #1
3 1338
NeoPa
32,556 Expert Mod 16PB
It's hard to comment on a design when you don't share it Dan ;-)
Jul 5 '12 #2
At least we could know what you're using. Let's see it Dan.
Jul 7 '12 #3
ariful alam
185 100+
if your database table has fields like below:

emp_name, emp_time_of_work, details

you have to make an query that takes parameter for emp_time_of_work like "between [full date/time format of now] and [full date/time format of now - 1]"
and you can run it in 1 hour tread to execute the query.
Jul 7 '12 #4

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

Similar topics

1
by: Rob | last post by:
Hi, I have a question, when you use a random number generator Random() in a loop to generate say 50000 random numbers; is it any difference if you use different time interval between each loop...
4
by: Andrew Poulos | last post by:
How do I convert a length of time, measured in seconds, into a "point in time" type time interval or what's represented as: time (second,10,2) The format is: PS]] where: y: The number of...
2
by: VB User | last post by:
I need to which time interval a given time is within. What is the function I can use?
1
by: greg chu | last post by:
Hi, not sure who has done this. I want to set up a time interval that could be pass midnight. so people can enter 8AM to 8AM (pass midnight to 2nd day) 8AM to 2 AM (pass midnight to 2nd day)...
0
by: achio84 | last post by:
Hi all, I'm a newbie in .Net programming. I'm developing a web application that has a listbox containing more than 1000++ items. This listbox is dynamic as the content will change on a time...
6
by: newsteve1 | last post by:
hi, this should be simple but its stumping me, I am trying to make a slideshow that pulls random images at a random time interval (between 1 and 4 seconds). The images part works fine, and I...
1
by: mndprasad | last post by:
Hi all I need a help here..am doing an application in jsp..i got struck in a position where i have not done that before There are multiple users in my application..for each user the time...
0
by: mariasoosai | last post by:
I have to send the jobs status that are started running from the previous day 9.00 a.m to today 9 a.m from the table sysjobhistory in sql server msdb database.But in that table , date and time are...
1
by: madankarmukta | last post by:
HI, I created the process which is hook to launch just before the Desktop appears and after the login credentials are entered by the machine owner.In Xp it is giving the expected result i.e. my...
4
by: yuvang | last post by:
i have a mdb located in server and n number of users are accessing and adding data to that mdb (source table). now i want to save the mdb tables in particular time interval frequently.
0
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,...
0
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$) { } ...
0
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...
0
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...
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
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...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.