I'm looking to create a report to replace the timesheets that our employees are now creating manually with a report. I would like their time to be displayed based on the time log entries that they enter throughout the day. So, for each day I would want it to show on 1/22/13 this person worked from 8:00am to 4:30 pm for a total of 8.5 hours. In each time log is a "start date/time" and an "end date/time" and I would like to pull just the time value from each field and then select or display only the earliest start time and latest end time for each day. If I try to do a minimum and maximum of each field, it is forcing me to use the date part and not the time. Is there a way to select the min and max based just on the time?

Thanks. The first option worked pretty well. There is one thing that I noticed that may present an issue.

There may be times that their time entries may not be entirely sequential. For example, they may have a time entry that runs from 2pm to 5pm, but in that time period they may enter another time entry say from 3pm to 3:30pm. With that 2nd entry and the way the report sorts by start date/time, it will put the 2nd entry last and therefore the end date/time of the last entry will be 3:30pm and not 5pm. Is there a way around that?