Time Calculation

[Antonio]

I have a table that contains three fields used to calculate time card data.
The table has:

Duty Date - short date format, duty day for employee...depending on shift
type, clock out time may flow across midnight, but will still be recorded on
previous date.
Start Time - General Date Format "12/12/2008 03:00:00 PM"
End Time - General Date Format "12/12/2008 03:00:00 PM"

I need to assign a particular code for times that fall between 2 pm and 6 am
in the morning. Example:
Employee starts on "12/12/2008 12:01:00 PM" and goes home at "12/12/2008
06:01:00 PM"

For the hours between "12/12/2008 12:01:00 PM" and "12/12/2008 01:59:59 PM",
the employee has a code "0" for each hour (or for calculation purposes
minute).

After "12/12/2008 02:00:01 PM" and up til "12/12/2008 06:01:00 PM, the
employee has a pay code of "1".

I want to total those hours with a pay code of 1 so that a differential pay
rate can be applied to the employees pay check but I am not sure how to write
an expression or code that will total the number of hours between the start
and end times and apply a specific counter for later calculations.

Any help would be greatly appreciated.

Thank you.

 

[Stefan Hoffmann]

hi Antonio,

For the hours between "12/12/2008 12:01:00 PM" and "12/12/2008 01:59:59 PM",
the employee has a code "0" for each hour (or for calculation purposes
minute).

Basically you need an expression like:

IIf(TimeValue([dt]) Between CDate("12:00") And CDate("15:00"),1,0)



mfG
--> stefan <--