[Help]How to get work hours from Time in and Time out of an employee for ms access.

[rhonixk08]

Hi to all expert,

I have a problem in ms access. How can i get the work hours of and employee in their Time in time out logs.

Example:
TABLE1.AM IN
08/08/11 9:00 AM

TABLE1.AM OUT
08/08/11 12:00 PM

TABLE1.PM IN
08/08/11 01:00 PM

TABLE1.PM OUT
08/08/11 6:00 PM

TABLE1.WORKHOURS
8

WHAT FORMULA SHOULD I USE TO GET THE WORK HOURS OF 8?

PLEASE HELP....

MANY THANKS IN ADVANCE.

 

[SydneyGeek]

Funny how questions sometimes arrive in groups...

See if this thread helps. That will give you hours, expressed as a time.
If you want the hours as a number, multiply by 24.

Denis

 

[rhonixk08]

Sir here's my codes formula in ms access forms, where there's a textbox of logs. AMIN2, AMOUT2, PMIN2, & PMOUT2.
I got an error on this formula, can you correct my codes sir?

Many thanks.

Private Sub click_Click()

Me.wrkhrs.Value = DateDiff((PMOUT2 - AMIN2 + (PMOUT2 < AMIN2)) - (PMIN2 - AMOUT2 + (PMIN2 < AMOUT2))) * 24

End Sub

 

[SydneyGeek]

If they are just entered as times (no date) try;

([AMOUT2]-[AMIN2]+[PMOUT2]-[PMIN2])*24

Of course, this assumes that PMIN is always later than AMOUT. You should have validation in place to make sure that users can't get it wrong.

Denis