Time Tracking with amount

[Scott]

I'm using the following Access database to track time
based on Time In - Time Out inputs, as per the following
link: http://support.microsoft.com/default.aspx?
scid=kb;en-us;237958&Product=acc
Now my question is I want to add a amount field to the
employees table that should contain the employee's hourly
rate so that in the query I should see the total amount
for the input, but the problem is that since it displays
HH:MM how can I count =TotalTime*EmpRate. ?

Thanks

Scott

 

[Jackie L]

Scott,
Take the value of ([TimeOut]-[TimeIn])*24 and then multiply that by the employee rate.

If you are going over midnight, there is more to the calculation since you are going to have to be concerned with the date also.

Hopefully, the above is enough.

 

[????]

I'm using the following Access database to track time
based on Time In - Time Out inputs, as per the following
link: http://support.microsoft.com/default.aspx?
scid=kb;en-us;237958&Product=acc
Now my question is I want to add a amount field to the
employees table that should contain the employee's hourly
rate so that in the query I should see the total amount
for the input, but the problem is that since it displays
HH:MM how can I count =TotalTime*EmpRate. ?

Thanks

Scott

 

[????]

I'm using the following Access database to track time
based on Time In - Time Out inputs, as per the following
link: http://support.microsoft.com/default.aspx?
scid=kb;en-us;237958&Product=acc
Now my question is I want to add a amount field to the
employees table that should contain the employee's hourly
rate so that in the query I should see the total amount
for the input, but the problem is that since it displays
HH:MM how can I count =TotalTime*EmpRate. ?

Thanks

Scott