Announcement

Collapse
No announcement yet.

Formula for Weekly Mileage and Cumulative Total

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • 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

  • #2


    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.

    Comment

    Working...
    X