Forum Discussion
Solved
Help with constructing avg. waitlist times using datedif function
I'm trying to calculate the average wait time for different types of apartments at my job. For example, I want to be able to differentiate the wait times between a one bedroom with a mini kitchen ver...
The DATEDIF formula results in a text string; that is useful for display purposes but you cannot calculate an average of text values.
Add a column with the simple formula =E2-D2. Format the cell with the formula as General and fill it down. It shows the wait time in days.
You can then create a pivot table based on the data.
Add the apartment type to the Rows area and the new column to the Values area. By default, Excel will sum the wait times, but you can change that to average in the Value Field Options dialog.
Sorry, missed your post
No problem!
Thank you both for your help - this is exactly what I needed to know 🙂
