willow1985
Well-known Member
- Joined
- Jul 24, 2019
- Messages
- 871
- Office Version
- 365
- Platform
- Windows
I suppose this is more of a math question but I also want to know if I am calculating this right in excel / would be getting the correct numbers.
I want to get the average turn around time (time between 2 dates) for the last 30 days.
My data is as follows:
<tbody>
</tbody>
(Note: There are multiple years so my formula only looks at 2019)
I have a Sum column and a Count Column and then an Average Column
I Sum everything on Oct 30: 8
I count everything for Oct 30: 2
I calculate the average for Oct 30: 4
Then at the end I average the average column for the last 30 days.
Would this give me the correct numbers for the average for the month?
This is probably a dumb question and something I should know but I seem to have a road block...
Thank you to anyone who can help me clear it.
Carla
I want to get the average turn around time (time between 2 dates) for the last 30 days.
My data is as follows:
Date 1 | Date 2 | Difference between dates | Sum | Count | Average | Average for the Month: 3.66 | ||
30-Oct | 01-Nov | 2 | 30-Oct | 8 | 2 | 4 | ||
30-Oct | 05-Nov | 6 | 29-Oct | 0 | 0 | |||
25-Oct | 02-Nov | 8 | 28-Oct | 2 | 1 | 2 | ||
28-Oct | 30-Oct | 2 | 27-Oct | 0 | 0 | |||
25-Oct | 30-Oct | 5 | 26-Oct | 0 | 0 | |||
25-Oct | 5 | 1 | 5 |
<tbody>
</tbody>
(Note: There are multiple years so my formula only looks at 2019)
I have a Sum column and a Count Column and then an Average Column
I Sum everything on Oct 30: 8
I count everything for Oct 30: 2
I calculate the average for Oct 30: 4
Then at the end I average the average column for the last 30 days.
Would this give me the correct numbers for the average for the month?
This is probably a dumb question and something I should know but I seem to have a road block...
Thank you to anyone who can help me clear it.
Carla
Last edited: