PDA

View Full Version : Total hours from selected records


helptosheik
Jul 21, 2008, 11:37 PM
I have one table and the fields are start time and end time. I'm already find working hours from stime and etime. But I want total working hours for selected records. i.e I want total hours for 10 selected records.. in msacces

ScottGem
Jul 22, 2008, 05:38 AM
How are you selecting the records? What version of Access? Does the start and end times ever span midnight (i.e start time in one calendar day and end time in the next). How do you want to display the total number of hours?