Child pages
  • Journal Statistics

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

=DATEDIF(ColumnHeaderRow#,ColumnHeaderRow#, "mdyd"); for example, for column headers Date Confirmed=K, Date Completed=L and the first row, the formula would be =DATEDIF(K2,L2, "mdyd")

Apply this formula to the rest of the "Time to Complete Review" row- note that reviews that are not completed will show an error message, as there will be incomplete fields. Get these out of the way by wither sorting the "Time to Complete Review" row and only selecting non-error cells for the average, or remove incomplete reviews from the spreadsheet and average all results. this should spit out a single number of days, the average length of days for a reviewer to complete a review for your journal.

...