Home |
Search |
Today's Posts |
#1
|
|||
|
|||
excell question
I'm working on a spread sheet and need to know if I can enter in a number
into a cell and have it automatically calculate what i want and put that number into another cell. What I want to do is enter in the hours someone has worked on one of several tasks and have it automatically calculate how much that is costing and have it put into a totals cell along with other people that have differing wages. I can send a copy of what I'm working on so you can see it if you really want to get into this thanks |
#2
|
|||
|
|||
excell question
Ross
It is likely a window of the same workbook (Should be Filename:1 or Filename:2. Simply close one and save the workbook -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England www.nickhodge.co.uk HIS "Ross" wrote in message ... I'm working on a spread sheet and need to know if I can enter in a number into a cell and have it automatically calculate what i want and put that number into another cell. What I want to do is enter in the hours someone has worked on one of several tasks and have it automatically calculate how much that is costing and have it put into a totals cell along with other people that have differing wages. I can send a copy of what I'm working on so you can see it if you really want to get into this thanks |
#3
|
|||
|
|||
excell question
Ross,
You haven't said how the calculation is to be performed. If the time, in hours, entered in the form hh:mm, or hh:mm:ss is in A2, and the hourly rate is in B2, put this in a cell: =A2*24*B2 If the hours are simple numbers, like 8, then use: =A2*B2 For a more specific answer, tell exactly what's in which cells. Earl Kiosterud www.smokeylake.com "Ross" wrote in message ... I'm working on a spread sheet and need to know if I can enter in a number into a cell and have it automatically calculate what i want and put that number into another cell. What I want to do is enter in the hours someone has worked on one of several tasks and have it automatically calculate how much that is costing and have it put into a totals cell along with other people that have differing wages. I can send a copy of what I'm working on so you can see it if you really want to get into this thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can I view an excell document without excell (not installed wit. | Excel Discussion (Misc queries) | |||
How do I find and replace a question mark in Excel? | Excel Discussion (Misc queries) | |||
insert query into excell sheet to update excell sheet and pivot table | Excel Discussion (Misc queries) | |||
Can I view an excell document without excell (not installed wit. | Excel Discussion (Misc queries) | |||
lable ranges in Excell | Excel Discussion (Misc queries) |