I've attached a copy of the workbook in my original post. Here's a
screenshot of what I'm working with:


In the first two columns, the user enters the start date & time. The
next columns are standard columns that he would enter information.

As an example, in the first column of time between 7:10AM and 9:29AM
he spent that time under "PERSONAL".
Throughout the day, his schedule utilizes the other columns:
PROPAGATION,EDIFICATION, and OTHER ACTIVITIES.

While I know it's a simple math formula to compare the first two cells
to find the difference in time, I need to find a way to find the amount
of time that is spent under each catagory.

The last spreadsheet in the workbook I have orginally attached contains
a summary page where the TOTAL time for each catagory would be
displayed.

Once I figure this out, the rest is cake. ANY help would be
aprechiated!