HOW TO CALCULATE RUNNING TOTAL
 

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....

HOW TO CALCULATE RUNNING TOTAL
 

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....