Prev: Macro question
Next: Sum Multiple Worksheets, same named cell
From: Jessica on 11 Mar 2010 13:27
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?!

From: Bernard Liengme on 11 Mar 2010 14:10
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" <Jessica(a)discussions.microsoft.com> wrote in message
news:FB7FC780-DA76-4BF9-9C43-581E0F1ED191(a)microsoft.com...
> 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?!
>
 | 
Pages: 1
Prev: Macro question
Next: Sum Multiple Worksheets, same named cell