Time format , which should I use?

[soundsfishy]

I need to store time or Hours spend on jobs by staff. Staff record the number of hours they spend working on a case. What format should I use to record hours?

I need to be able find out how many hours staff have spend working on client case and on what date they worked on the cases.

What is the best way to set up my table. Should I have a separate table hours ? Should I make the Hours table as a juntion table. So one one side I have Staff and the other side I have case details.

I was thinking of sett'n up the tblhours something like this:. Any suggestions anyone?

StaffID FK
CaseID FK
Date
TimeStart
TimeEnd

CaseID PK
CaseNumber
ClientName etc

StaffID PK
Surname etc

 

[R. Hicks]

If you are storing "TimeStart" and "TimeEnd" in your table ... you do not store "Hours".

You calculate the elasped time (Hours) "on the fly" dynamically when the value is needed.

RDH