#1
|
|||
|
|||
Units worked per time period
Please help! I'm a newbie and I can't seem to get this simple thing right!!
Using military time. Example: A1 - 7/1 23:19 A2 - 7/2 00:15 A3 - =(A2-A1) Custom [h]:mm??? A4 - 98 General?? A5 - ????? I'm trying to get the average time for the 98 units. I have two separate teams working on the 98 units during the same time period of 58 minutes, but need to show the total 98 even if it is really 49. I have tried several different formulas and no success. Also I would like to exclude the date but not sure how to do that if work goes from one day to the next with military time. How do I get to the .84 time? It seems simple but I can't get it to work out.. working with Excel 2002 |
#2
|
|||
|
|||
I've read your post a half dozen times and can't figure out much from it. Perhaps if you attached your sheet, it would provide much of the explanation.
As for "excluding the date", you can format dates and times to display in myriad ways. But the underlying data in the cell is always a floating point number where 0 is midnight on 1/1/1900 and each day thereafter adds 1. Fractions of days are decimals, an hour being 1/24, a minute being 1/(24*60), etc. So you can display just the time in those cells, but when you type in the data, your calculations won't work if the times span two days unless you explicitly enter the times as such. If you just enter 23:19 and 0:15, Excel will enter both as those times on the same day, 1/1/1900, and the calculation will return 23 hours and 4 minutes. Properly subtracting the later time from the earlier... [7/2 00:15] - [7/1 23:19] = 0.038889 This is the fraction of one day that the difference of those times (56 minutes) is. 56/(24*60) = 0.038889 |
#3
|
|||
|
|||
Ya sorry about that I worked through the night and sent the question at the end of my day. Basically in this case I have 98 items to inspect. 98 items are split in half by two inspectors. They take a total of 56 mins to inspect. What is the average inspection time.
|
#4
|
|||
|
|||
Ahhhh...gotcha. Check out the attached file. I haven't added in that there are two inspectors. That will double the average time. I'll have that presently.
|
#5
|
|||
|
|||
The average time is 0:01:09 (1 minute, 9 seconds).
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How do I calculate planned work for a given time period | bumpui | Project | 1 | 06-04-2014 06:37 AM |
Can you see how much time I worked on Word 2007/2010 document when converted to PDF? | Papa Bear | Word | 1 | 08-14-2012 05:14 AM |
Allocation of task in certain period of time | mati2 | Project | 1 | 02-25-2012 07:59 AM |
Can't change period when adjusting actual time in Web Access | chip_saffire | Project | 0 | 10-04-2011 12:05 AM |
Add a period of time to a referenced "Time" cell? | derelyth | Excel | 4 | 03-27-2011 04:31 PM |