I am relatively new to Excel and am trying to come up with the monthly average cycle time for a series of dates. I have attached an example spreadsheet and would appreciate a formula.
I am relatively new to Excel and am trying to come up with the monthly average cycle time for a series of dates. I have attached an example spreadsheet and would appreciate a formula.
Try this formula
=AVERAGE(B2:B27)-AVERAGE(A2:A27)
Audere est facere
=AVERAGE(B2:B27-A2:A27) and then press Ctrl-Shift-Enter to create the matrix
Click on the star if you think I helped you
Thanks so much - you just saved me a ton of time!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks