I'm working on an access project where I must calculate the pay of a contractor for my company. I seperated the contractors into multiple departments, and they are paid according to their rate type (Straight Time, Over Time, Double Time...). I want it set up so that when I select the department and rate type, the program will select its rate automatically,

Also I'm looking for a way to find the difference between a period of time (sometimes over 24 hours) accuratley. The way I currently have it set up it's only accurate to the hour, i need it with decimals.

TIA

-Billy Bob Joe

Hi,

Change the calculated time difference to minutes and then devide by 60

(DateDiff("n",[TimeIn],[TimeOut]))/60
Format should be fixed

Garry