Updating "Actual Hours" via an external file to give a "Remaining Hours" figure.

Hi there,

We are wanting to add more data into our boards around hour tracking.

Currently the test board structures look like this:

Target Hours - Set per milestone
Actual Hours - Hours spent per milestone so far
Remaining Hours - Formula to remove Actual from Target

Our main system for accounting and hour tracking can export into a txt, csv, or xls file which has e.g.;

Column 1:
Milestone
Row 1 - L28
Row 2 - L29

Column 2:
Actual Hours
Row 1 - 6
Row 2 - 4

I am wanting to be able to import one of these report files and use it to overwrite the actual hours (if this can be automated that is great but we don’t mind manually importing once a day).

What is the best way to do this?

Ideally it would look like “If milestone L28 is in board, replace with Actual Hours”.