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.