Time Calculation - Calculate Total Cost Per Job Per Person?
Dec 22, 2013
I am attempting to create a time chart that keep track how long a particular person works on an individual project to finally calculate profit & loss. Attached is the spreadsheet.
I am using invoice #'s to differentiate the jobs but have no clue how to make it calculate how much time was spent per job, per person then calculate the total cost per job per person?
sheets.time chart.xlsx
2014 tab- grey column is installer and white is shop employees
profit loss tab- all calculations done here
payroll tab- all cost data here
View 1 Replies
ADVERTISEMENT
Jan 26, 2014
I am trying to keep a running total of cost, here is what I am doing
A B C D E F G H I
Date Books Pencils tax Month Books Pencils Tax Total
1/2/2014 11.50 2.50 .76 January 35.85 13.50 3.44 52.79
1/5/2014 14.50 3.85 .83 February 10.95 1.50 .68 13.13
1/6/2014 9.85 7.15 1.85
2/6/2014 10.95 1.50 .68
I only used Jan and Feb as an example. So as you see on the right side I will have all 12 months for the year and I just want all the totals for each month to auto calculate. I will have between 15 and 30 entries each month.
View 5 Replies
View Related
Apr 21, 2006
I would like a lookup that takes multiple criteria and that is not an array formula! Unfortunately I decided to use array formulae and my spreadsheet went to over 45mb!! Not good. I've searched the forum for an answer to my questions but couldn't find any! I've attached a spreadsheet as an example. The examples I am using have {Sum(IF)} formulae in it (array) and I would like to change those to others that will not increase the file size so much and will not take too long to calculate.
Basically, I would like a lookup that will return me the Amount Paid and Full Cost based on the person's name and the date. the data and the results table are both on separate sheets. It would be nice to bring that file's size back down to less than 4mb!!
View 7 Replies
View Related
Jun 22, 2009
I am trying to build a spreadsheet to calculate how many hours have elapsed between to entries; start time (H10) e.g. 9:15 AM and end time (I10) e.g. 12:15 PM. The formula that I am using in the calculation cell field (J10) is (I10-H10+(I10<H10))*24. This formula works great till I wish to include in an IF statement. What I would like is if the total hours calculated with the formula (I10-H10+(I10<H10))*24 is less than 4, return 4 (hours) otherwise the value. As well if there is no start time nor end time entered then return zero.
View 3 Replies
View Related
Aug 13, 2012
Below is my data
Complexity Type
Name
1
2
3
4
5
6
7
Ali,Shaheen Sultan
8
34
34
6
0
0
0
Budati,Manoj Kumar
7
18
18
12
6
0
0
Based on above data if The Column heading is 1 then it needs to go to the below data and multiply by that value and at the end should give me the total for the person. note that the total time is captured in a different sheet.
Complexity
Times Complexity 1
1
1.00
2
1.41
3
2.03
4
2.92
5
3.19
6
4.10
7
4.65
View 6 Replies
View Related
Nov 27, 2013
I have a form which captures below details.
Label 1 = Time when form initialized or opened
Label 2 = Running Time (Live Time)
Label 3 = Total Time (Label 2 - Label 1)
Now what I need is since Label 2 is live time which shows the running time, Label 3 displays the total time spent. I want to display total time as running time.
e.g.
Label 1 = 13:01:00
Label 2 = 13:05:10 (running time/live time) which will keep ticking
Label 3 = 00:04:10 (I want even this as running time which keep running when label 2 is running)
View 1 Replies
View Related
Dec 12, 2007
Date Start End Total
12/8 - 2:00 3:00 = 1
12/8 - 4:00 5:00 = 2
12/8 - 20:00 21:00 = 5
12/9 - 23:00 0:00 = 3
12/9 - 3:00 4:00 = 4
=SUMIF($A:$A,">="&TODAY()-1,D:D)/24-SUMIF($A:$A,">"&TODAY(),D:D)/24
In the example above, E2 calculates the totals between 12/8 and 12/9 giving me 15:00. What I want the formula to exract is the total from Col D the total from 12/9 to the previous 24hrs.
12/8 has 2 entries, and 12/9 has 3 entries. The total I want to extract in 24 hours, NOT 1 day, is 14. What formula can I use that will calculate the totals in 24 hrs.
View 4 Replies
View Related
Mar 15, 2007
In a financial environment we have a calculator which uses iteration to allow for a cost being added to loan amount where the cost is based on the total loan amount. Iteration is set to 100 iterations with max change .001
On one PC the first time the calculator is opened it gives a particular (incorrect) result. If the input cells are cleared and the data re-entered, it gives the correct result. This only happens on one particular PC. Is there some other setting , other than the iteration setting, that would cause this?
View 5 Replies
View Related
Aug 4, 2013
I am trying to determine the total hours of downtime accumulated when there are 2 or more machines down during the same time period. To do this, I need to be able to determine if at any point there are 2 or more pieces of equipment down at the same time, and if this is true, how many hours were overlapped. The attached spreadsheet shows how the data is presented.
View 7 Replies
View Related
Sep 17, 2012
Any way to calculate the total hours staff work based on the mininum time of the first transaction to the maximum time of the transactions. I used a DMIN and DMAX function to get those times per employee. The issue is then the time goes over from one day to the next, such as from 11 PM to 4 AM the next day. As you can see in the data below,the fourth record shows the minimum time as 12 AM and the max as 11 PM with total time worked as 23 hours. In this example, the total hours worked should be five hours.
min time
max time
total hours
7:00 AM
16:00
9:00
[Code] .......
View 4 Replies
View Related
Nov 14, 2008
Need a ormula that will calculate various lengths of time within a column.
For example: I would like to be able to add
02:43 (2 minutes 43 seconds) plus
01:10 (1 minute 10 seconds) plus
05:15 (5 minutes and 15 seconds)
..and accurately arrive at the sum of
09:08 (9 minutes 8 seconds)
Currently, whenever I input the value of 02:43- and assign the value of 'TIME'.. it reads it as 14:23 (clock time..not length of time.) I will only be using data that follows the format of mm:ss (minutes:seconds).
View 2 Replies
View Related
Aug 15, 2007
I need to create a formula to calculate monthly hours worked (144.20) by hourly rate (£14.25). So far everything ive tried has given me awrong answer. I cant seem to make the total right. From what ive come up with (Not good) the total accepts the hours-just not the minutes.
View 8 Replies
View Related
Aug 10, 2009
I have a simple VBS script that puts the username & current time in columns. When the user saves that time is also placed into a column.
I would like to be able to calculate the amount of time a user has spent on the spreadsheet for the current month & if possible the total time all users have spent on the spreadsheet this months.
View 8 Replies
View Related
Mar 26, 2014
I am trying to calculate the total amount of kilos for a specific date with a given time range.
As well as the average time they have been handled with in the same specifications.
Attached is a sample sheet of the info I am working with but I cant seem to get the formulas to work.
Book1.xlsx
View 9 Replies
View Related
Oct 1, 2008
I need a formula that will scan column A (Code)total the like items (also) add column B (Qty) if there is a number greater than 1. Then add the price ($) together and divide by the sum of A&B.
In other words find the average price for the total of each item..
A B C
Code Qty $
PH06003000 1 1504.8
PH06003000 1 1582.24
PH06003000 1 1606
PH06003000 1 1504.8
PH06003000 2 3009.6
PH06003000 1 1504.8
PH06003000 1 1504.8
PH06003000 1 1504.8
PH06024000 1 2499.2
PH06024000 1 2499.2
PH06024000 1 1896.07
PH06024000 2 3909.66
PH06024000 1 2240.7
PH06024000 1 2259.4
PH06024000 15 30030
PH06024070 1 2039.4
PH06024070 1 1958.66
PH06025670 1 2521.2
View 9 Replies
View Related
Jul 9, 2012
I'm struggling with the VBA DATEDIFF function. I have a person's DOB and am attempting to determine their age by comparing to a different date. It seems like their age only changes when I change the year, rather than choose a date within the year past their birth date... Here is my code:
Sub Test_click()
DOB1 = #7/19/1930# 'DOB
date2 = #7/18/2012#
Date3 = #7/21/2012#
age1 = DateDiff("yyyy", DOB1, date2) 'age should be 81 (but is 82)
age2 = DateDiff("yyyy", DOB1, date2) 'age is 82 (correct)
End Sub
View 5 Replies
View Related
May 13, 2014
We have a bar code scanner that scans employee IDs as they come and go each day. Beside the ID is the date/time stamp in the next column. They do not always come in in the same order they leave, so I am looking for a solution that will collect the in and out time for each ID, then add those times beside each employee name, and add them for a hourly total.
View 10 Replies
View Related
Aug 6, 2009
I need to calculate the total cost of outbound calls based on the total duration of outbound calls multiplied by cost per minute. For example, in a given month, the total duration of outbound calls is 261:16:34 being 216 hours, 16 minutes and 34 seconds. I have this figure in cell A1 with the format [h]:mm:ss. I then convert this to minutes in cell B1 by saying B1=A1, but having the format [m], which gives me 15676. In cell C1, I have the cost per minte value of £0.026. But when I apply the formula D1=B1*C1, I get £0.283, when 15676*£0.026 should in fact be £407.58.
View 2 Replies
View Related
Aug 5, 2014
Pivot_example.jpg
Regarding the attached pivot table screen shot, I would like to be able to add total revenue and cost for each product and overall to this pivot table. IOW, instead of just showing the net amount of 3,200 for all blenders, I would like it to show Revenue of 12,500, Cost of (9,300), and the net amount of 3,200 for all blenders (i.e., for Boise and Chicago combined), in addition to the totals for each of the two plants. Also would like to see total revenue, cost, and net for all products and plants combined at the bottom. Can this be done?
View 4 Replies
View Related
Apr 15, 2008
I am trying to create a simple formula to extract cost from a total that includes both cost and and a percentage for maintanance. Assume $100, 10% of which is maintenance the remainder is cost. If I just subtract 10% from $100 I get $90, however 10% of $90 is $9 which equals $99.
View 8 Replies
View Related
Dec 14, 2008
I need a macro to calculate the cost basis of the inventory. ( Field F3 and F4 in Sheet1)
Please refer to attached sheet....
View 7 Replies
View Related
Jun 10, 2014
Looking for a formula for total cost based on a list of hours for each employee and a table of rates for each employee.
Please see attached file : Formula.xlsx‎
View 1 Replies
View Related
Sep 21, 2009
use the “INDEX & MATCH” formula and I thank him very much for that. Now, I have another problem which I think the “IF & ELSE” statement may come into play. I am trying to calculate the cost of a cushion that is governed by it’s thickness.
Example:
ABCDEFGHI
1CushionB/FrontS/SideBorderQuantitySeat
2Feather121251£8.25
3Feather121241£7.32
4
B2 represents 12 inches
C2 represents 12 inches
D2 represents 5 inches
144 represents square foot
The calculation is,
F2=B2*C2/144*D2*£1.65*E2..............
View 4 Replies
View Related
Mar 5, 2014
I need to set up an easy to use spread sheet for my office. It needs to be able to calculate the running total spent of fuel, as well as include any discounts we get and then calculate our total savings.So basically, total spent and total saved.
View 3 Replies
View Related
Apr 29, 2014
Drop down menu that can pull data for 1 person at a time from Table?? (Even possible)
View 1 Replies
View Related
Mar 23, 2007
I am trying to put together a spreadhseet that will calculate the future cost of education fee assuming a given inflation rate. I would like the reuslt to be highlihted in a list or a table. The user would only need input current fee, inflation rate and years where fees are payable. The spreadsheet would do the rest. I have laid this our best I can attached.
View 5 Replies
View Related
Aug 14, 2006
I am compiling a simple worksheet that will keep an ongoing track of labour costs in a production environment. The objective is to end up with a labor cost "per unit" for packing punnets of soft fruit.
The source data I have is;
1 - Start time and end time of the job
2 - Any breaks taken during the job
3 - The number of staff it took to do it
4 - The status of the staff (Supervisor, temp, etc) and their hourly pay rates
5 - The number of punnets packed.
With all of the above it should be a relatively simple exercise to calculate the cost per unit (and with a calculator is!). My problem appears to be that I am not formatting something correctly, because when I try to calculate the costs for the employees' my costs are obviously wrong. I have attached my early draft for reference, in the example shown I am showing that a supervisor earning £7.50 an hour worked for 1 hour 15 mins at a cost of £0.39
View 2 Replies
View Related
Sep 12, 2013
I need to develope a macro for Excel to calculate desired profit margin depending on our cost of each item. Here's the scenario.
A1: landing cost
If 0
View 4 Replies
View Related
Oct 17, 2007
I have costs per minute and call times in seconds
How do I work out the cost per call in Excel?
It's probably something very simple, but I just can't work it out. No matter what I try, I can't get it right
View 9 Replies
View Related
Oct 22, 2008
I need to calculate below hours
07:50
07:50
07:50
07:50
07:50
The answer suppors to be 37:30 Hours but its showing total diffrent value. i used sum(E1:E5) Excel formula, but its not working.
View 10 Replies
View Related
