Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 113
Default 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?!

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
RUNNING Avg - how? Boswell Excel Discussion (Misc queries) 2 November 11th 08 04:43 AM
Running Sum? RichieK Excel Discussion (Misc queries) 2 June 11th 08 08:16 PM
running sum Pammy Excel Discussion (Misc queries) 1 October 13th 07 09:37 PM
Keep Running Tab sarah Excel Discussion (Misc queries) 3 March 21st 07 04:33 PM
Running Add-In from VBA BillCPA Excel Discussion (Misc queries) 1 April 4th 06 04:48 PM


All times are GMT +1. The time now is 10:10 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"