Alright everyone, I'm deployed and got tasked to creat an excel spreadsheet to track total miles, hours, and fuel on our vehicles. The idea is that we can enter the info along with a date in one line when we fuel up, then go to the next line at the next fuel stop. Then have the total number of miles/hours for the month total up in one cell each at the bottom (i.e. 2000 miles to 2100 miles, to 2200 miles would total to 200 at the bottom). I want to keep it "Army Proof" (Go Air Force, no offence to any Army on the forum), so I'll need to figure out how to lock the cells with the formulas too. Thanks!
Date Miles Hours Litres
1-Aug-13 22430 734 41.4
4-Aug-13 22462 745 59.4
5-Aug-13 22474 751 26.8
Totals 44 17 127.6
Bookmarks