Let's say the Km-start value is in cell C1 and the Km-return value is in
Cell D1. The in cell E1 type =D1-C1 to get the difference
If you have columns of data you can copy this formula down the column by
dragging the fill-handle (the solid black square in the lower right corner
of the selected cell)
I do urge you to get a book like Excel for Dummies so you can find out all
the time saving things Excel can do for you
best wishes
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email
"MTLCOOCOO" wrote in message
...
i WORK WHERE WE DO CAR RENTALS AND THE PROBLEM IS THAT i WANT THE
KILOMETERES
TO BE COUNTED.
i HAVE THE KM WHEN THE CLIENT LEAVED ( A ) WHEN HE COMES BACK ( B) BUT i
CAN
FIGURE OUT HOW TO GET (C) TO AUTOMATICALLY CALCULATE THE KM DRIVEN. I
HAVE
TRIED TO READ THE FORUMS BUT MAYBE MY LITTLE MIND CANČT GRASP IT.
ANY HELP?
THANKS IN ADVANCE....