#1
|
|||
|
|||
Calculating Average Time across days
We are doing a time study most of the times are in the same day but we have a few that go across an evening. I have the row calculating the total days, hours and mins and that part works fine but I need to total the time and do an average. When you add a day it does not do it correctly.
Here is an example: Time Study Formulas.xlsx I need the Total Time and the Average Time Any suggestions appreciated...... I am at a loss...... |
#2
|
||||
|
||||
It's easier to calculate the difference B2-A2 and format the results as D:hh:mm instead of returning formatted text.
Then Sum and Average are easier to find and formatted as needed
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
#3
|
|||
|
|||
Thanks
I will try that..... I guess I was making it too hard.....
|
#4
|
||||
|
||||
Try the attached. I think you'll find it more accurate, especially concerning your highlighted entry
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Calculate Average Time Elapsed in Days, hours and minutes | Nina46 | Excel | 9 | 09-11-2015 02:09 AM |
Calculating Turnaround Time | shstone | Excel | 4 | 12-11-2014 12:39 PM |
Calculating 6.5hr work days | altja | Project | 3 | 02-10-2014 03:11 PM |
36 days task at 40% effort - only "0.86 days" in resource | hanvyj | Project | 9 | 07-09-2013 07:27 AM |
5 days/week during planning & 7 days/week during implementation | sanlen | Project | 1 | 06-25-2012 04:17 PM |