Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Calculate Duration of Time for an Employee

Calculate Duration of Time for an Employee

Calculate Duration of Time for an Employee

I want to do the calculation on 'xyz' memory table in Clarion:
I have fields loaded in Memory table from reading a .Dat file as:
Emp No. Shift    PunchType    LastName    FirstName    Date    PunchTime
111111111    1      1            John        Doe        04/24/2011     7:30 AM
111111111    1      2            John        Doe        04/24/2011     4:00 PM

Things I want ToDo:
1)I want to calculate the Duration(in time hours) of a particular employee depending upon his Shift
For eg. Shift 1 will have a lunch break and will deduct 30 mins from the total duration time.
2)Shift 2 will not have a lunch break and should give me total duration of time.
3)Shift 3 will be little bit different to calculate, though there will be no lunch.
For example :  If PunchTime(In) on date 04/24/2011 will be 11:00pm and PunchTime(out) on 04/25/2011 will be at 4:30am.


Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close