Timesheet Calculator

This resource has been built as an additional tool to assist clients in processing their timesheet exports from Fleet Centre. Download the Timesheet Calculator by clicking icon below:

Staff_template_import.png

Timesheet Calculator

Timesheets - Exporting Timesheets from Fleet Centre

In Fleet Centre, navigate to Timesheets and select "Export Timesheets". From here, we will be able to select our date range and along with any optional filters:

Screen_Shot_2021-09-08_at_2.29.57_pm.png

A new window will open, allowing us to select which columns we require in the CSV file. Select the following:

  • Person Name
  • Day Worked
  • Start Time
  • Finish Time
  • Break Time
  • Total Time

Screen_Shot_2021-09-08_at_2.58.07_pm.png

Excel - Copying Timesheet Data into Timesheet Calculator

Once our Timesheets CSV has been exported from Fleet Centre, we should see a list of timesheet entries with the columns we selected while exporting:

Screen_Shot_2021-09-08_at_2.59.16_pm.png

Select this data and copy it from the Timesheet Export. Now, navigate to the Timesheet Calculator spreadsheet and select the second sheet, titled "Data". We will notice this page will be empty by default. Paste the data we copied from the Timesheet Export into Cell 2A:

Screen_Shot_2021-09-08_at_3.04.18_pm.png

Once this data has been pasted into the timesheet calculator, we will notice columns G to M will automatically populate:

Screen_Shot_2021-09-08_at_3.07.38_pm.png

Timesheet Calculator - Refreshing Pivot Table

Navigate back to the first sheet, titled "Time Sheet Info". On the blue and white table, right-click and select "Refresh". This will pull the information that we pasted into the data sheet earlier:

Screen_Shot_2021-09-08_at_3.10.52_pm.png

Screen_Shot_2021-09-13_at_12.34.24_pm.png

Timesheet Calculator - Reading Output Data

From the table produced, we can see a breakdown of the hours each employee worked for the selected date range. Saturday hours, Sunday hours and overtime are outlined in their respective columns: 

Screen_Shot_2021-09-13_at_12.36.13_pm.png

   
Was this article helpful?
0 out of 0 found this helpful