In the attached file under tab November Stats, cell C9
I'm trying to get the average time for closed work orders.
B9 extrapolates the number of work orders closed in Dept 5811 with the code "CAP"
It shows one job, when I look in the archive section it shows in cell N1108 that it had 133 days in queue.
The formula I'm using must not be correct, it's giving me 33.25 days.
What am I doing wrong?
You have mismatched criteria:
This:
Should be this:
Please Login or Register to view this content.
Is that something you can work with?Please Login or Register to view this content.
It's returning the same value 33.25
in the archive for that one job it was in queue for 133 days.
I:
• opened your file
• copied the second formula I posted
• Selected cell C9 on the November Stats tab of your workbook
• Pasted the new formula into the formula bar...Replacing the prior contents
Cell C9 returned: 133
You did that and you see something different?
I'm sure it's me, long day not seeing straight.
Could you do me a favor?
Please copy to my spreadsheet and attach it.
I'll try to figure out what I did wrong in the morning.
Thanks so much.
Matt
I tried it in the light of day.
You were spot on.
Thanks so much.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks