/
Editing Timecards using Excel

Can't find what you're looking for? Still have questions? Contact customer support (smile)

Editing Timecards using Excel

Owned by Jason Ng
23 Oct 2024
2 min read

DPF Timecards can be edited in Excel using the following steps:

  1. Select the timecard, navigate to the ellipsis (3 dot) menu on the top right hand side and select Export → Excel Timecard.

    image-20241023-012750.png

     

  2. This will generate an Excel spreadsheet similar to the screenshot below. Edit the spreadsheet by amending the various columns as needed.

  3. Once done, copy the amended lines to be imported back into DPF by selecting columns A to AF, right click and choose copy. Alternatively, you can use the Ctrl-C shortcut.

image-20241023-013442.png

  1. Go back to DPF, select import from the ellipsis menu and paste (right click → paste or use Ctrl-V) in the Excel data into the import pop-up window and click Save.

  1. A green pop-up text box will appear on the top right if the data was imported successfully.