Results 1 to 13 of 13

Macro to add total hours

Threaded View

  1. #1
    Registered User
    Join Date
    03-08-2013
    Location
    usa
    MS-Off Ver
    Excel 2003
    Posts
    39

    Macro to add total hours

    Thanks in advance for any help you can provided. I have a spreadsheet attached consisting of over 19000 rows. There is blank row after each workweek have ended. the total daily hours are in Column I. I am looking for a macro that will either look at Column E "wed" or column I see total daily hours above the blank row, Add those totals and display the results on the blank row in Column H.

    Thanks in advance.

    if it not much asking, I added the blank row. before that there were none. is possible, if there a macro that will just look for wed in column E. and then automatically insert the row and does the same operation as above.

    Thanks
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Total hours and paid hours calculation advice
    By lozzauk in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 03-27-2013, 08:25 AM
  2. Replies: 0
    Last Post: 02-07-2013, 08:42 PM
  3. [SOLVED] Decimal Time to Hours and Minutes over 24 hours in total
    By FlyingTiger in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-17-2012, 06:18 AM
  4. Adding daily run hours to cumulative total hours
    By Rodstew in forum Excel General
    Replies: 8
    Last Post: 08-08-2012, 07:10 PM
  5. Replies: 6
    Last Post: 05-03-2010, 12:03 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1