Calculate Shiftwise Work

Posted on 2007-10-08
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
    LVL 1

    Accepted Solution

    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

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Join & Write a Comment

    This article describes how to add a user-defined command button to the Windows 7 Explorer toolbar.  In the previous article (, we saw how to put the Delete button back there where it belongs.  "Delete" is …
    After several hours of googling I could not gather any information on this topic. There are several ways of controlling the USB port connected to any storage device. The best example of that is by changing the registry value of "HKEY_LOCAL_MACHINE\S…
    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.…
    In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…

    733 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

    Need Help in Real-Time?

    Connect with top rated Experts

    20 Experts available now in Live!

    Get 1:1 Help Now