How to Calculate time worked?

[Chris Petrone]

Hello,

My organization has asked to be able to link sc_task with pm_project_task to better track the work being done for said Project. I have setup a link by creating a new reference field on the sc_task record, and linking it to pm_project_task, and then adding a related list tab on the pm_project_task.

What they are now wanting is a way to somehow update the time worked in the sc_task to the time worked on the pm_project_task. I figured instead of getting this to update, which I feel would be messy to implement, I could possibly just add a new time field to the pm_project_task and somehow calculate the value of the linked sc_task(s).

It looks like this requires a script for the calculation. Anyone have any ideas if this would work or can help with the script? I've included some screenshots to show what I've done.