Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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?! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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?! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
RUNNING Avg - how? | Excel Discussion (Misc queries) | |||
Running Sum? | Excel Discussion (Misc queries) | |||
running sum | Excel Discussion (Misc queries) | |||
Keep Running Tab | Excel Discussion (Misc queries) | |||
Running Add-In from VBA | Excel Discussion (Misc queries) |