Calculating times and taxes

[nfpk]

Hi!
I have a table with four fields:
startdate
starttime
enddate
endtime
Its a database for facturing the prices for personalhire.
There are different taxes on worktime between 0.00-6.00
6.00-18.00 and 18.00-24.00
I want the database to automatically calculate
how much to factorise.
What method is the best?
Is it possible to program this?
nfpk

 

[Ecniv]

tblPersonelHireDetails
PersonelID
StartDate
StartTime
EndTime
FactorID


tblTaxFactors
FactorID - Auto
Factor - double

You have to store the factors for each period - means more data entry, but easier than getting the computer to divide up the time.

Up to you of course, as otherwise you have to spilt the dates/times against factors.


Vince

 

[nfpk]

Thanks Vince!

I think this is a good idea. I try it.
I thought of something similar.

nfpk