I want to create a database to log hours worked on a job, and then at the end of the day print out a timecard. how should I set my tables up to make it all work? I cant seem to think of a efficient way off doing it. I was thinking having a table with the job number and its info in one table, then another table for the actual day that Im working which would log the time worked on a job. I would have multiple jobs in a day which would be printed out and total number of hours worked on the bottom. can someone please turn me in the right direction?

Here how the loging would work I work, I would have to select the date then
say I worked on job#1 from 7-9, Job#2 from 9-10, Job#3 from 10-2
and so on. Then at the end of the day I would print the time card out and turn in.