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: Timesheet Calculator |
||
Timesheets - Exporting Timesheets from Fleet CentreIn 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: A new window will open, allowing us to select which columns we require in the CSV file. Select the following:
|
||
Excel - Copying Timesheet Data into Timesheet CalculatorOnce our Timesheets CSV has been exported from Fleet Centre, we should see a list of timesheet entries with the columns we selected while exporting: 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: Once this data has been pasted into the timesheet calculator, we will notice columns G to M will automatically populate: |
||
Timesheet Calculator - Refreshing Pivot TableNavigate 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: |
||
Timesheet Calculator - Reading Output DataFrom 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: |
||