Go Back   TechArena Community > Software > Windows Software
Become a Member!
Forgot your username/password?
Register Tags Active Topics RSS Search Mark Forums Read

Sponsored Links



automatic subtraction in excel

Windows Software


Reply
 
Thread Tools Search this Thread
  #1  
Old 09-02-2011
Member
 
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

Reply With Quote
  #2  
Old 10-02-2011
Member
 
Join Date: Dec 2007
Posts: 2,219
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
Reply With Quote
  #3  
Old 10-02-2011
Member
 
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
Reply With Quote
  #4  
Old 10-02-2011
Member
 
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.
Reply With Quote
Reply

  TechArena Community > Software > Windows Software
Tags: , , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


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


All times are GMT +5.5. The time now is 07:58 AM.