Loading
Ozgrid Excel Help & Best Practices Forums

Excel Video Tutorials / Excel Dashboards Reports



Results 1 to 2 of 2

Thread: Formula for Weekly Mileage and Cumulative Total

  1. #1
    Join Date
    8th April 2012
    Posts
    1

    Formula for Weekly Mileage and Cumulative Total

    I am trying to build a spreadsheet that will track the miles and hours of use on our Rental Fleet. Today the drivers post the odometer and clock readings on the log and we manually calculate the miles and hours for the week. I have attempted the formula but end up with a negative cell for the current week until an actual number is posted. I am trying to eliminate the negative cells. I have attached the spreadsheet with detailed comments.

    It looks so easy but I can't seem to figure it out. Any help would be appreciated.

    Thx,

    Tommy
    Attached Files. REMINDER! OzGrid accepts no responsibility for ANY adverse effects as a result from downloading attached files. ALWAYS run an up-to-date virus scan and disable macros.

    Excel Video Tutorials / Excel Dashboards Reports


  2. #2
    Join Date
    5th March 2012
    Posts
    167

    Re: Formula for Weekly Mileage and Cumulative Total

    Rental Truck Mileage.xlsx

    Try that out. If certain cells are blank, then the formula returns blank so the totals will work correctly.

    Excel Video Tutorials / Excel Dashboards Reports


Thread Information

Users Browsing this Thread

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

Possible Answers

  1. Cumulative total of changes?
    By JohnathanStein in forum EXCEL HELP
    Replies: 5
    Last Post: January 31st, 2012, 17:31
  2. Calculating Cumulative Total?
    By jeevi in forum EXCEL HELP
    Replies: 4
    Last Post: January 22nd, 2007, 10:37
  3. Cumulative Total with a twist
    By zipper21 in forum EXCEL HELP
    Replies: 1
    Last Post: April 3rd, 2006, 21:16
  4. looking for cumulative total formula or fumction
    By chef richard in forum EXCEL HELP
    Replies: 3
    Last Post: May 3rd, 2005, 18:04
  5. calculating cumulative mileage
    By hunteryik in forum EXCEL HELP
    Replies: 7
    Last Post: February 11th, 2005, 14:33

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
  •  
porno