Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 07-24-2014, 04:47 AM
carmang carmang is offline Units worked per time period Windows XP Units worked per time period Office XP
Novice
Units worked per time period
 
Join Date: Jul 2014
Posts: 2
carmang is on a distinguished road
Default 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
Reply With Quote
  #2  
Old 07-24-2014, 07:27 AM
gebobs gebobs is offline Units worked per time period Windows 7 64bit Units worked per time period Office 2010 64bit
Expert
 
Join Date: Mar 2014
Location: Atlanta
Posts: 837
gebobs has a spectacular aura aboutgebobs has a spectacular aura about
Default

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
Reply With Quote
  #3  
Old 07-24-2014, 07:38 AM
carmang carmang is offline Units worked per time period Windows XP Units worked per time period Office XP
Novice
Units worked per time period
 
Join Date: Jul 2014
Posts: 2
carmang is on a distinguished road
Default

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.
Reply With Quote
  #4  
Old 07-24-2014, 08:20 AM
gebobs gebobs is offline Units worked per time period Windows 7 64bit Units worked per time period Office 2010 64bit
Expert
 
Join Date: Mar 2014
Location: Atlanta
Posts: 837
gebobs has a spectacular aura aboutgebobs has a spectacular aura about
Default

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.
Attached Files
File Type: xls Inspection.xls (23.0 KB, 7 views)
Reply With Quote
  #5  
Old 07-24-2014, 08:24 AM
gebobs gebobs is offline Units worked per time period Windows 7 64bit Units worked per time period Office 2010 64bit
Expert
 
Join Date: Mar 2014
Location: Atlanta
Posts: 837
gebobs has a spectacular aura aboutgebobs has a spectacular aura about
Default

The average time is 0:01:09 (1 minute, 9 seconds).
Attached Files
File Type: xls Inspection.xls (23.5 KB, 13 views)
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Units worked per time period 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
Units worked per time period Add a period of time to a referenced "Time" cell? derelyth Excel 4 03-27-2011 04:31 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:47 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft