I have a table in which I store times in short format of hh:mm, which is the amount of time I spend at a job. Each record also stores the job name. At the end of each week I need to run a report that adds up the total time spent at each job. The problem is I can't figure out how to add up short times like that and come up with a total. Please no vba or sql (I'm an access novice at this point but I'm learning fast) unless it's the only way to solve this.