How to copy or move hours from one client or project to another?

  1. Go to the page of the project you want to move.

    Add a module Chart & Table, and select the report: Time spent per Projects
    Select a wide time period that encompass all the hours you want to move, eg: from 1/1/2000 to 1/1/2020.
    Click the link at the bottom right: Save as a spreadsheet

    A CSV file will be downloaded to your computer.


  2. Open the CSV file in your spreadsheet editor.
    Insure you keep only the lines you want to change.




  3. Change the content of the project column or any other column: company, task, person...



  4. Move, rename and delete the columns of the CSV file to match the import file format time import that is used by the Import module.



  5. Here is an example of the columns renamed to the import format.



  6. Add the relevant project, client or person in the system that matches the CSV file.
    In this example we add the project: new project to the client: Electracom




  7. Add Import to your home screen.
    Choose the option: Time entries
    Pick the date format you used in your CSV file
    Then click import your file

    If you run multiple imports, check well the results before each import, as you can only undo the last import.



This procedure is worth the effort if you have many lines to copy or move.

If you want to delete a company or a project with many hours, contact us at http://support.beebole.com