Hi,

I have an employee mastertb that has the following fields employee name, city, work catagory, logdate, a start time, a finish time and a duration time that defaults to 3 hrs if start and finish time are < 3hrs. The mastertb is updated on a daily basis at the end of each day.
I want to create a table from the mastertb to show employee name, city, certain work catagories and sum the duration feild. However when I try to sum the duration in hours and minutes I get a number similar to 2.00001233 instead of hours and minutes as displayed in the mastertb? How do I format/sum the duration field???

Cheers

...DEZ...

If those fields you quote are in the same table, your structure is wrong.

Employee data should be only entered in an Employees table. Logon data like date, TimeOn and TimeOff etc should be separate with a FK to link to EmployeeID.

One to Many. . . . .One employee can have many LogOns

Col