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......

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

Attached Files

Copy of Time Study Formulas.xlsx (14.3 KB, 9 views)

__________________
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

I will try that..... I guess I was making it too hard.....

Try the attached. I think you'll find it more accurate, especially concerning your highlighted entry

Attached Files

Time Study.xlsx (9.9 KB, 8 views)

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]