Results 1 to 4 of 4

Thread: automatic subtraction in excel

  1. #1
    Join Date
    Feb 2011
    Posts
    2

    automatic subtraction in excel

    Hi all ,
    I am a newbie to this forum , so excuse me if im a posting this to the wrong forum

    I have a simple requirement.
    I have this timesheet at work where i need to compute the time each employee spent on a specific task.
    So that said i have only 5 colums in my excel :name of employee, task, starting time ,ending time and duration.
    I can do the subtraction manually to obtain the duration, for example =D1-C1 , this is excessively time consuming. I would like to automate this. whereby when the employee input the starting and ending time, excel automatically calculates that for me. is this possible??
    thanks in advance
    BTW : am not an excel expert

  2. #2
    Join Date
    Dec 2007
    Posts
    2,297

    Re: automatic subtraction in excel

    Try to use the below example

    Code:
    =IF(C2<>"",$D$1-SUM($C$2:C2),"")
    into cell D2 and copying down the column by use of the fill handle (the tiny square at the bottom right of the selected cell.) for as many rows as you envisage using. Addition of values in column C should make the calculated values appear

  3. #3
    Join Date
    Feb 2011
    Posts
    2

    Re: automatic subtraction in excel

    Hello EINSTEIN ,
    thanks for your reply.What should i do with the code , where should i paste it? as i told you am not excel expert
    thanks

  4. #4
    Join Date
    Nov 2008
    Posts
    1,259

    Re: automatic subtraction in excel

    You should enter the same at the point where you need to get the automated result of the employees. Just mention it on the cell where you needed the output and make the changes as per the cell number of your and it will automatically detect the entries and shows the result for same. So if you can then go through the same and see this is working for you or not.

Similar Threads

  1. Automatic Filter on Hyperlink in Excel
    By Mike Chester in forum Software Development
    Replies: 2
    Last Post: 17-03-2012, 12:36 PM
  2. Automatic filtering in Excel
    By RenNoClue in forum Software Development
    Replies: 4
    Last Post: 27-01-2012, 07:08 PM
  3. How to Automatic update the date in Microsoft Excel
    By Raju Chacha in forum MS Office Support
    Replies: 1
    Last Post: 14-01-2012, 01:57 PM
  4. How to avoid the Automatic Creation of Hyperlinks in Excel?
    By sivaranjan in forum Windows Software
    Replies: 5
    Last Post: 11-03-2010, 03:41 AM
  5. Sizing automatic font in Excel
    By Aadils in forum Software Development
    Replies: 2
    Last Post: 26-11-2008, 11:40 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •