Multiple rows, same date, multiple start/end times... how might I...

[hutch]

I have a workbook that has a sheet with:

multiple consecutive rows each have the same date.
then the date changes for another set of consecutive rows like this (pastes
excel cells below - hope you can see it?).

Date Start Time End Time Daily Total Running Total
Friday, August 01, 2003 8:00 AM 11:00 AM 3.00 3.00
Friday, August 01, 2003 11:00 AM 11:30 AM 0.50 3.50
Friday, August 01, 2003 12:00 PM 2:15 PM 2.25 5.75
Friday, August 01, 2003 2:15 PM 4:30 PM 2.25 8.00
Friday, August 01, 2003 4:30 PM 6:00 PM 1.50 9.50
Wednesday, August 06, 2003 8:00 AM 9:00 AM 1.00 10.50
Wednesday, August 06, 2003 9:00 AM 10:15 AM 1.25 11.75
Wednesday, August 06, 2003 10:15 AM 11:00 AM 0.75 12.50


How can I on another sheet:
show this same info but consolidated so that each row shows a single date
with a consolidated consecutive start/end time. I would want to watch for
consecutive times so that if there happens to be a break in the time (like
for lunch say) then I would add another row for that date? Can this be done
with simple formula, or does VBA have to be incorporated?
Note: This is a time/task tracking device... in cells you don't see here
(pasted cells above), I have a task category that is selected from a list
box. Then on another sheet I calculate total time spent for each of the
task category as well as the percent of the total time.

Thanks for help of this forum! It rocks!