record business mileage

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Crazy Rev - 31 Dec 2004 17:59 GMT

I want to know if I can record business mileage using Excel, and separate
business miles from personal and commute miles? I want to divide monthly and
run a continuing total for the year. This is primarily for the I. R. S.
requirements. Thanks

Reply to this Message

Ted Metro - 31 Dec 2004 19:43 GMT

I would create two rows - one named business, one named personal and have 12
columns (one for each month). Then just punch in the numbers every month and
have Excel sum at the end of the year.

Do you know how to add 12 cells in Excel?

> I want to know if I can record business mileage using Excel, and separate
> business miles from personal and commute miles? I want to divide monthly and
> run a continuing total for the year. This is primarily for the I. R. S.
> requirements. Thanks

Reply to this Message

Crazy Rev - 31 Dec 2004 23:57 GMT

> I would create two rows - one named business, one named personal and have 12
> columns (one for each month). Then just punch in the numbers every month and
[quoted text clipped - 6 lines]
> > run a continuing total for the year. This is primarily for the I. R. S.
> > requirements. Thanks

Ted:
No. I do not know how to add 12 cells in Excel. Can I add daily mileage
traveled under a heading for "business," "commute," and "personal" miles? Is
this feasible to do? Thanks --RAJ

Reply to this Message