Create a constituent export

  1. On the Output tab, select Volunteer, Timesheets, Hours
  2. Enter a start date and end date. You will also be prompted to enter a number for the amount of timesheets to export per constituent during that time period
  3. Add any additional fields you need to the Output tab
  4. Export in Excel format
  5. The hours will be exported across the rows in Excel. For example:
  6. In the first available column, create a formula that will automatically add up the numbers in each row. In the above example, the summation formula in cell F1 would be =sum(A1:E1)
  7. Copy this formula into the remaining rows of the spreadsheet