Thanks for the speedy reply. I figured it could be done in a chart but couldn't figure out what the formula should be, because as you make selections on the date or task the hours logged will be available but I couldn't figure out how to get the total hours.
Any suggested formulas?
To get that table, assuming the field names you have provided in the post, it should be something like the following:
FTE: LOAD Name, Date, Sum(TimeSpent) AS TotalTimeLoggedForDay RESIDENT TableWithTasks GROUP BY Name, Date;
If you can replace the RESIDENT by a FROM qvd file the result will be quite faster.
Hope that helps.