J
Jessica
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?!
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?!