To design what you have in mind, I need to ask you a few questions. Do you want to be able to type in the ending mileage from time to time, and have the spreadsheet show you how many miles you've driven since the last time you recorded the mileage, and also show the total miles driven since 55,227? Is there anything else you want to show?
no that will be fine!
location start mileage end mileage
i need it to be within a month-make it 650 miles
Please see attached spreadsheet. In the second tab, I included the same table, but filled in with example numbers so you can see how the table looks filled out. You would only fill in columns A and C. The rest of the table is calculated automatically. If this is not exactly what you had in mind, please clarify and I'd be happy to make modifications. Thanks.
Sure, I can do that. How many entries do you need? I can do 4 entries at 162.5 miles for each location, or 5 entries at 130 mile for each location, etc.
i like the format!!!
i need a thirty day entry totalling 650 miles, not the same mileage numbers. different mileage numbers for everyday but a total of 650 miles for the whole month at the end