Timesheet data by Milestone

Timesheet data by Milestone

Hi

What is the simplest way of getting timesheet data by Milestone?  I can do it by Project since the timesheet table contains ProjectID, but it doesn't contain Milestone ID.

Ultimately, I'm trying to calculate the cost of a milestone based on submitted timesheets, multiplying the hours by the cost-per-hour rate to put on a Dashboard.