Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium


Calculate Shiftwise Work

Posted on 2007-10-08
Medium Priority
Last Modified: 2008-01-09
Dear all Experts
Can any body halp me how to mark attendance in shiftwise duty.

for Eg.
 Duty starts from
7am to 3 pm (Ist Shift)
3 pm to 11 pm (2nd shift)
11 pm to 7 am(3rd shift)
Here i m facing problem in calculating attendance for 3rd shift, bcoz, date is changing in this case, And if someone takes half day leave things will become more complexity. anybody have any solution for this?
thanks in advance
Imran Rauf Qureshi
Question by:imran_qureshi
1 Comment

Accepted Solution

yvijayakumar earned 150 total points
ID: 20058007
Start the shift with a relative date. e.g. If you are marking the attendance for the day 11/Oct/07, use this date as relative date for the shift. Using this method you can simply identify the day shift starts.

Use variables as <Date, Shift Code, Start Time, End Time, Relative Date>
Date = Transaction Date
Relative Date = The day in which the particular shift starts

Featured Post

[Webinar On Demand] Database Backup and Recovery

Does your company store data on premises, off site, in the cloud, or a combination of these? If you answered “yes”, you need a data backup recovery plan that fits each and every platform. Watch now as as Percona teaches us how to build agile data backup recovery plan.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

What my article will show is if you ever had to do processing to a listbox without being able to just select all the items in it. My software Visual Studio 2008 crystal report v11 My issue was I wanted to add crystal report to a form and show…
For a while now I'v been searching for a circular progress control, much like the one you get when first starting your Silverlight application. I found a couple that were written in WPF and there were a few written in Silverlight, but all appeared o…
This is Part 3 in a 3-part series on Experts Exchange to discuss error handling in VBA code written for Excel. Part 1 of this series discussed basic error handling code using VBA. http://www.experts-exchange.com/videos/1478/Excel-Error-Handlin…
With just a little bit of  SQL and VBA, many doors open to cool things like synchronize a list box to display data relevant to other information on a form.  If you have never written code or looked at an SQL statement before, no problem! ...  give i…

564 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question