Unfortunately, MIN and MAX are not options when summarizing Time fields in a Summary Report. I don't know that there's going to be a way to show what you're looking for in a Summary Report. For the option of a Table Report, you will need a parent record above the level of the individual Time Cards so that you can do a Summary Field for Min Start Time and Max End Time. That table would need to be setup so that each record would be unique to the Sales Rep and Day, so you'd end up with a structure kind of like this:
Sales Reps < Sales Days
Sales Reps < Time Cards
Days < Sales Days
Sales Days < Time Cards
You could then do a Summary Field for Min Start and Max End from the Time Cards up to the Sales Days and do your Table Report on the Sales Days table.
------------------------------
Blake Harrison
bharrison@datablender.io
DataBlender - Quick Base Solution Provider
Atlanta GA
404.800.1702 /
http://datablender.io/------------------------------
