Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 1
Default 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....
  #2   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 4,393
Default 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....



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Duplicate Running Total Grand Total In Pivot Table Mathew P Bennett[_2_] Excel Discussion (Misc queries) 1 August 17th 08 03:13 AM
How can I use a formula to calculate a running sub-total in excel LossManiac Excel Worksheet Functions 2 June 20th 08 01:52 PM
running total and average of that total after 3 events belvy123 Excel Discussion (Misc queries) 0 March 28th 07 02:57 AM
running total and average of that total after 3 events Toppers Excel Discussion (Misc queries) 1 March 28th 07 02:19 AM
calculate count on 2006 total, 2005 total, etc... Amanda Deshotel Excel Worksheet Functions 6 September 28th 06 11:59 PM


All times are GMT +1. The time now is 11:36 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"