Macro Challenge – Create Table with Hours Worked and Copy Data

[ske97]

Here's my challenge. I'd like to track the amount of time spent on
project from unique rows within the "Project List" worksheet. When
touch the project, I envision inputting the number of hours (30 minute
= 00:30) in the "Hours" column on the "Project List" spreadshee
(attached.) I'd like to take that value, as well as some other value
on the same row (Column A, the project ID, Column B, the project name
column R, the last edited date and Column S, the number of hours) an
append them to the "Project Hours" tab. Ideally, this function woul
clear off the "Hours" in the "Project List" tab after that occurs, bu
that's not a necessity.

I could then update that project the same or days later with additiona
hours, and subsequently append it again to the same spreadsheet. Thi
could also apply to other rows (e.g. projects) within the "Project List
spreadsheet.

From the "Project Hours" worksheet, I could then build reports to sho
the total time spent on a project (I can handle that piece!)

What I'm struggling with is the code to get the data from "Project List
and append it to "Project Hours" without having to manually the hour
over each time.

I've tried to simplify the spreadsheet as much as possible to simplif
review