Running Sum
 

How do I calculate a running total for specific functions? My example is as
follows
A B C D
E F
1 Function: Email Phone Email Faxing Prepping
2 Start Time: 4:25 PM 6:15 AM 6:30 AM 7:05 AM 7:50 AM
3 End Time: 5:05 PM 6:25 AM 6:35 AM 7:30 AM 8:00 AM

4 Total Time(min): 40 10 5 25 10

In another Cell, for example B6, I want to total up the total time of all
Email (B4+D4), Phone, Faxing, Prepping etc. The user is picking from a
validation list in fow 1, so this will vary and the time will total
automatically in row 4. As user moves along in the spreadsheet I need to keep
a running total of the Total Time (row 4) the user select the specific driver
in row 1.

Help?!

Running Sum
 

If I understand correctly:
Function: Email Phone Email Faxing Prepping Phone
Start Time: 4:25 PM 6:15 AM 6:30 AM 7:05 AM 7:50 AM 8:15 AM
End Time: 5:05 PM 6:25 AM 6:35 AM 7:30 AM 8:00 AM 8:25 AM
Time 0:40 0:10 0:05 0:25 0:10 0:10
x
Function: Email Phone Email Faxing PreppingTotal
0:45 0:20 0:45 0:25 0:10In B4 I have =B3-B2; this is copied across the row
The x is to show an empty row (for prettiness)
In B7 I have =SUMIF(1:1,B6,4:4); this is copied to F7

Any use?
best wishes
--
Bernard Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme


"Jessica" wrote in message
...
How do I calculate a running total for specific functions? My example is
as
follows
A B C D
E F
1 Function: Email Phone Email Faxing Prepping
2 Start Time: 4:25 PM 6:15 AM 6:30 AM 7:05 AM 7:50 AM
3 End Time: 5:05 PM 6:25 AM 6:35 AM 7:30 AM 8:00 AM

4 Total Time(min): 40 10 5 25 10

In another Cell, for example B6, I want to total up the total time of all
Email (B4+D4), Phone, Faxing, Prepping etc. The user is picking from a
validation list in fow 1, so this will vary and the time will total
automatically in row 4. As user moves along in the spreadsheet I need to
keep
a running total of the Total Time (row 4) the user select the specific
driver
in row 1.

Help?!